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?