Take a look at "Conditional Formatting" in XL Help.


In article ,
"joe" wrote:

Is it possible to use an IF to change the color of the text of a cell. E.g.
I want to write "If the value is above 0, then make the text color black. If
it isn't then make it red."