Formula?

D

Doug

Is there away in a "IF" statement, that you can change the
color of a cell based on the statement? example:
If b9>b20 make b9 red ?
 
S

Stefan Hägglund [MSFT]

Hi Doug!

You should use the Conditional Formatting in the Format menu.
Here you can change the formatting for the cell based on the value.

Best regards

Stefan Hägglund
Microsoft
 
L

Leif

See Format/Conditional Formatting. There you can set color etc based on the
contents.

Regards
Leif
 
N

Nanda

Hi,
I don't know if you need a formula, but the option conditional formatting
exists, in: format/conditional formatting.

Nanda.



"Doug" escreveu:
 
Top