**5**

votes

**1**answer

7k views

### Excel 2007: Conditional formatting so that each row shows low values yellow, high values red

I have a spreadsheet with approx 300 rows. Each row has about 15 columns, and each cell contains a numeric value. Each row corresponds to a product.
I want to get Excel, for each product, to ...

**-1**

votes

**2**answers

2k views

### Excel conditional formatting comparing date and time to current date and time

I have a style sheet in which I have to dates with times
-----------------
29/09/2011 12:00
29/09/2011 14:00
-----------------
If current date and time is 29/09/2011 11:50 then row is green
If ...

**0**

votes

**0**answers

32 views

### Excel: use formula in cell format [duplicate]

Possible Duplicate:
Excel: use formula in cell format
Is there a way to use a formula as a cell format?
AFAIK, conditional formatting allows only static format applied based on some ...

**-1**

votes

**1**answer

468 views

### Excel 2007 conditional formatting formula problem

I have the following problem. I have a sheet where the current month should be highlighted. For this I used the formula for conditional formatting. The formula for the first three months is like this:
...

**1**

vote

**1**answer

514 views

### How can I set conditional formatting to check for equality between columns?

I have a dataset like this in Excel:
A B
1 X X
2 X Y
3 Y X
4 Y Y
I want to set up conditional formatting such that rows 1 and 4 will be highlighted as green because their A and B cells are ...

**3**

votes

**1**answer

13k views

### Conditional formatting of TRUE / FALSE values in an Excel 2010 range

I have a range containing formulas that evaluate to TRUE or FALSE.
How would one apply conditional formatting to this range, so that TRUE cells are Green, and FALSE cells are RED?

**1**

vote

**2**answers

363 views

### Advanced spreadsheet auto-formatting

Is it possible to autoformat spreadsheet like this
IF A1 = C1 then A1:E1 cells background becomes light gray
I use OO Calc, but it's ok if you know how to do it in MS Excel or Google spreadsheet

**1**

vote

**1**answer

261 views

### conditional formatting of entire row from a cell's value in that particular row in Excel 2007

I have viewed the answer for a similar question. If I have several rules for a particular row, (e.g. if cell A2 is 1 then the row is red, if 2 then row is blue, if 3 then row is green, etc...). Having ...

**2**

votes

**1**answer

3k views

### How do I use conditional formatting in a spreadsheet based on dates?

I have a spreadsheet in OpenOffice V3.3.0 (used in Windows 7 32 bit). One column contains dates (in the format: 14 August 2011 ) and I want to use conditional formatting on those cells depending on ...

**1**

vote

**3**answers

315 views

### Excel Conditional Formatting for Cell condition in Range

How do I reference another cell in my conditional formatting?
I want an entire range to highlight in green if a particular cell in that range is populated with "y".

**1**

vote

**2**answers

765 views

### Excel conditional formatting of row

Can someone please tell me how to highlight multiple cells in a row based on some values in any one of a given number of cells?
For example, if in Row 2 any of the cells from D2 to L2 have value "A" ...

**5**

votes

**1**answer

20k 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

**1**answer

522 views

### Excel conditional formatting multiple repeating rows

I'm using Excel 2010
I have a monthly menu. menu days are listed by row with 2 menu items list for each day.
Col-C Col-D
Day 1
Cheesburger
Hamburger
Day 2
Taco
Quesadilla
Day 3
...

**1**

vote

**4**answers

3k views

### Excel: struggling to use CF to highlight differences between columns in the same row

I have a list of vaules in column A and column B. I need to highlight where there is a difference between values that are in the same row.
I've used a simpe formula in B1: $A1<>$B1 (format bold). ...

**0**

votes

**2**answers

2k views

### Apply strike out text on row

I have a question about Excel 2007 and I'm not sure if its even possible, but if any community can help it's here.
I want to strike out all the text for all cells in a row if the text in column A ...

**2**

votes

**1**answer

2k views

### Excel: Detect #N/A (German: #NV) for conditional formatting

I have a huge Excel sheet where I regularly import mass data into. This data is input to calculations per row. Sometimes, the imported data results in a #NV error in the calculated data.
I would ...

**1**

vote

**1**answer

1k views

### Conditional format - change a cell to specific color based on formula

I need to color a cell in Excel 2007 based on a statement like, if B6=H and C6=g then color A6 Blue
I have no idea what the proper script would be but here is my guess that does not work: ...

**2**

votes

**1**answer

663 views

### Conditional Formatting to highlight cells with highest frequency

I have an Excel table like the following:
1 2 3 4 5 6 7 8
----------------------
3 3 3 3 3 1 1 1
4 4 5 4 4 4 4 3
and I need a conditional style to highlight the items with the ...

**2**

votes

**1**answer

3k views

### Excel: Conditional Formatting (Highlighting) Values Based on Another Worksheet

I have a workbook that has two worksheets.
The first worksheet is simply a list of the first 78,498 prime numbers in a single column, A1-A78498.
The second worksheet has a grid of numbers from 1 to ...

**4**

votes

**2**answers

3k views

### How can I alternate grid background color in excel when a value of a single column changes?

How can I alternate grid background color in excel when a value of a single column changes?
Such as this:
I would want to do this with conditional formatting, but I can't figure out how to.

**0**

votes

**5**answers

3k views

### How to delete all data on hdd other than Windows 7 [duplicate]

Possible Duplicate:
What's the best way to completely remove everything from a computer, without re-installing?
I have to return my company laptop. It has windows 7 on it. I want a way ...

**1**

vote

**1**answer

123 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 ...

**1**

vote

**1**answer

430 views

### Adding conditional formatting to the status line in GNU screen

In GNU screen in the status it is possible to put conditional things, such as
%?%F%{+b r}%:%{+b b}%?
%F is the test; if true it turns on bold red formatting %{+b r}, whereas if false it turns on ...

**3**

votes

**8**answers

25k 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, ...

**1**

vote

**1**answer

128 views

### Excel 2007 formatting using a range

I'm formatting a calendar on multiple sheets in excel, with the weekends highlighted. I'd like to format all the sheets from a table of 1s & 0s I generated to match different years. Unfortunately, ...

**0**

votes

**3**answers

10k views

### How to hide number but keep Excel cell background color?

I got a sheet like the below figure. I want to hide all the number and just keep the background color. How can I do it?

**3**

votes

**2**answers

2k views

### Excel conditional formatting based on a formula

I would like to use Excel's conditinal formatting of a particular column based on values in two other columns.
I have values in columns A, B, C and D.
column A has text values (any value user ...

**2**

votes

**1**answer

176 views

### Conditional Formatting in Excel

I have a worksheet with a series of rows A1 - H1 etc and a drop down list which lives in H1, I would really like to change the cell styles of all the cells between A1 - H1 based on the value in H1.
...

**1**

vote

**2**answers

3k views

### Excel Conditional Formatting Offset Greater than

I need to create a conditional formatting rule that will apply some color if the cell to the left has a value greater than 500, however it is not accepting my formula:
=OFFSET(0,-1) > 500
Can ...

**1**

vote

**1**answer

1k views

### Conditional Formatting of a Cell Based on Color Value in that Cell in Excel

Is is possible to format a cell based on one component of the RGB value inside of it. For example, let's say I have 3 cells - A1, A2, A3. In A1, I want the cell color to be the shade of red anywhere ...

**13**

votes

**2**answers

5k views

### Excel Conditional Formatting Escaping a Question Mark

I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn ...

**1**

vote

**1**answer

1k views

### Excel 2007 Conditional Formatting is not properly using custom formula provided

In Excel 2007, I want to conditionally color a row if it is odd numbered and then vary the coloring depending on if a specific cell (in column E) in that row contains a number (green) or empty(red). ...

**0**

votes

**3**answers

383 views

### CF: Cell STATUS + Cell DATE compared to NOW(DATE) = Colour

If the status in cell $D5 is "AWAITING FEEDBACK" I want to compare the DATE in cell $H5 against TODAYS DATE and CONDITIONAL FORMAT cell $H5 using the data bars formatting (colour to transparent).
If ...

**5**

votes

**2**answers

3k views

### Colour coding blocks of rows using conditional formatting

My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore.
Using Excel ...

**0**

votes

**1**answer

228 views

### How do I format each cell in column FOO in Excel if the len() of the cell value is longer then BAR?

If this is the wrong place to ask this let me know.
Here is the formula I have right now:
=LEN($A$2)>$AB$11
Applies to:
=$A$2
That works great for the one cell. I need it to apply to each ...

**0**

votes

**1**answer

613 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 ...

**2**

votes

**1**answer

4k views

### Excel - conditional formatting in Shapes?

For a long time, I didn't think it was possible to have a Shape (e.g., Text Box) have a value set by formula, but it turns out you can. Similarly, it appears that you can't apply conditional ...