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?

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?

hilight the cells where the results are and go 'format'...'conditional
formatting' then
Cell value....is equal to...."OK" click the format button and make the text
color Green.
then click on the 'Add' button and do the same thing except of course make
the words 'Not okay' and make the colour red.


"Call of Duty" wrote:

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?

Use Conditial Formating on the Menu!

Meny: Format - Conditional Formating

Condition 1: Cell Value is equal to OK then.... Set the format to green
Condition 2: Cell value is equal to Not OK then set the forma to be red




"Call of Duty" <Call of skrev i melding
...
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?