Aren't the two conditions the same?

Use the formula

=G19G18

in CF and format as green, and

=G18G19

and format as red

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Call of Duty" <Call of wrote in message
...
I have the following formula:
=IF(AND(G18<G19,G19G18),"OK,"NOT OK")
I want the answer "OK" to be the color Green.
I want the answer "Not OK" to be the color Red.
How do I do this?