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.


--
Air Lancer

[Bob Phillips]

You need conditional formatting.


Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help



--
HTH

Bob Phillips

"Air Lancer" <chesserhawk-email.yahoo.com.sg> wrote in message
news:[email protected]...
> 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.
>
>
> --
> Air Lancer

[Quo Vadis]

"Air Lancer" wrote:

> 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.
>
>
> --
> Air Lancer