Hi!

Try this:

Assume that formula is in cell A1.

Select cell A1
Goto FormatConditional Formatting

Condition 1
Select Formula Is from the drop list
Enter this formula in the little box to the right:

=A1="OK"

Click the Format button
Set the font color to be GREEN

Click OK

Click the Add button

Condition 2
Select Formula Is from the drop list
Enter this formula in the little box to the right:

=A1="Not OK"

Click the Format button
Set the font color to be RED

OK out

Biff

"Mbtgb" wrote in message
...
I am using an IF statement that returns an "OK" or "NOT OK" statement. Can
I
get the "OK" to print in Green and the "NOT OK" to print in Red.