Changing color of font in IF statement?

  • Thread starter Thread starter DrB
  • Start date Start date
D

DrB

Have a calculation for a cell using an IF statement. When true I want the
calculated number to show up green; if false the font color should be red.
Is this possible and how?

Does the same approach work for positive and negative numbers, respectively?
 
Hi DrB

Have a look at "Conditional Formatting"

--
XL2002
Regards

William

(e-mail address removed)

| Have a calculation for a cell using an IF statement. When true I want the
| calculated number to show up green; if false the font color should be red.
| Is this possible and how?
|
| Does the same approach work for positive and negative numbers,
respectively?
|
|
 
I should not have mentioned negative numbers since this misled you. I am
comparing cell value with another cell to see if it is greater or less than
the other cell. If less, I want the answer to come up in red color. If more,
then black color. Is this possible?
 
All the same, take a look at Conditional Formatting,

Search for in XL Help...

You should be able to do any type of comparisson...

Format.Conditional Formating. add a condition....

Cheers
Juan
 
Back
Top