IF statement

[joe]

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."

 

[JE McGimpsey]

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

 

[CLR]

"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]

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

Thank you!

 

[joe]

"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

Thank you, thank you!