Wording's Colour Change for Logic Function
 

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(M100, "OK", "NOTOK")", "OK" will appear as Green colour wording,
and "NOT OK" as Red colour wording.


--
Air Lancer

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

--
Andy.


"Air Lancer" <chesserhawk-email.yahoo.com.sg wrote in message
...
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(M100, "OK", "NOTOK")", "OK" will appear as Green colour
wording,
and "NOT OK" as Red colour wording.


--
Air Lancer