"Conditional Formatting" is the feature you want.........highlight the cell,
then do Format ConditionalFormatting and follow the menu to set up your
conditions.........

Vaya con Dios,
Chuck, CABGx3


"joe" wrote in message
...
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."

--
joe
http://www.angelfire.com/ny5/jbc33/