View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kathrine J Wathne
 
Posts: n/a
Default How do I create conditional formatting?

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?