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.

You can use Conditional Formatting from the Format menu to do
this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


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

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.