How do I create conditional formatting?

C

Call of Duty

I have the following formula:
=IF(AND(G18<G19,G19>G18),"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?
 
B

Bob Phillips

Aren't the two conditions the same?

Use the formula

=G19>G18

in CF and format as green, and

=G18>G19

and format as red

--

HTH

Bob Phillips

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

Tim M

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.
 
K

Kathrine J Wathne

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
 
Top