Wording's Colour Change for Logic Function

[Air Lancer]

Hi all,

any1 know how to create "IF" function such that the Value it presents is of
a certain colour for different condition?

E.g.: "=IF(M10>0, "OK", "NOTOK")", "OK" will appear as Green colour wording,
and "NOT OK" as Red colour wording.

 

[Guest]

Hi
Have a look at Format|Conditional Format. There is some info on it here:
http://www.cpearson.com/excel/cformatting.htm