Print IF return "OK" or "NOT OK" in different colors

M

Mbtgb

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

Chip Pearson

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
 
Top