Extended conditional formatting

Asus Eee pc 1005ha blue netbook
April 21, 2010 at 00:56:19
Specs: Windows XP, 2096
Hi everyone,

The subject is how to make the "extended" conditional formatting of cells and namely:
One cell (let's say A1) has the values "Y" or "N".
Depending on this two values some calculation in another cell (let's say A5 is performed or no (=0).
Please not that the cell A5 cann also have the value 0 as the result of "normal" operation.

I'd like to know if it is possible to change the bacground color of the cell A5 depending of the value put in the cell A1 (i.e. if Y put in A1 --> A5 in green, if N put into A1 --> A5 in red).

Thanks a lot in advance for your help!


See More: Extended conditional formatting

Report •

April 21, 2010 at 01:15:27
This is basic Conditional Formatting, so I'm not sure what you mean by "Extended".

You didn't say what version of Excel you are running, so for 2003 it's:

1 - Select A5
2 - Format...Conditional Formatting
3 - Condition 1 Drop Down - Formula Is:


4 - Format button
5 - Patterns tab
6 - Select color
7 - Click OK
8 - Click Add
9 - Condition 2 Drop Down: Formula Is:


10 - Format, Pattern, etc.

For Excel 2007 it's something like Add New Rule.

P.S. to save keystrokes, this also works in both versions:


which uses the "logical values" for TRUE and FALSE.

Report •

April 21, 2010 at 01:48:09
Hi DerbyDad,

I thought that the "normal" formatting of the cell A5 was depending on the cell A5 itself so I've called the formatting of A5 in dependace of A1 as "extended" one.

So I should try your suggestions and I hope it'll solve my issu.

Best regards


Report •

April 21, 2010 at 04:31:42
Works OK!

Thank you!


Report •

Related Solutions

Ask Question