1
vote
1answer
32 views

Conditional formatting excel conundrum

I have a list of values in excel. I would like to highlight a cell if its more than 1.5 higher or lower than the value before it or after it. Is this possible? Thanks guys!!
-1
votes
1answer
35 views

Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...
0
votes
1answer
787 views

Why am I getting unexplained vertical lines in the center of merged cells?

I am working on a spreadsheet that merges 20 columns into a single row. This row is conditionally formatted to display a data bar, of a proportional length based on a set of values from 0 to 275 that ...
2
votes
4answers
453 views

Is it possible to have a conditional formatting cell “visually cycle” through all the formats that evaluated true?

Like the title says, "In Excel, when a cell has multiple conditional formatting rules that evaluate true, is it possible to have the cell "visually cycle" through all the formats that evaluated true? ...
5
votes
1answer
18k views

Color Cell Based On Text Value

An Excel column contains a text value representing the category of that row. Is there a way to format all the cells having a distinct value a unique color without manually creating a conditional ...
1
vote
1answer
121 views

Is there a formula that I can use so that I can get a cell on Sheet 1 to have exactly the same formatting as a cell on Sheet 2?

I am using an excel spreadsheet to record skill competencies of staff. Sheet 1 will act as a "master" sheet reflecting the skill competencies of all staff (ie different employee in each column) and ...
3
votes
6answers
21k views

Prevents cells from printing in Excel

Is it possible to prevent the contents of specific cells (or entire row or column) from printing in Excel? I need to maintain the cell size. I've been setting the text color to white before printing, ...
0
votes
1answer
610 views

Outlook 2007 - Conditional Format based on Users declining a meeting

I recently set up a meeting with a colleague but must have ignored the fact that he had declined. So I showed up to the meeting alone. Is there any way to conditional format my Outlook 2007 calendar ...