Asus Eee pc 1005ha blue netbook

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!

Zennon

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:=IF(A1="Y",TRUE,FALSE)

4 - Format button

5 - Patterns tab

6 - Select color

7 - Click OK

8 - Click Add

9 - Condition 2 Drop Down: Formula Is:=IF(A1="N",TRUE,FALSE)

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:

=IF(A1="Y",1,0)

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

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

Zennon

Works OK! Thank you!

:-)Zennon

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History