Conditional Format text Excel 2003

  • Thread starter Thread starter Rhonda
  • Start date Start date
R

Rhonda

I am trying to Condtionally format cells that have two other numerical
condtions.
I'd like the last condition to be... When typing "OK" or "ACCEPT" the cell
to change green.
 
In Conditional Formatting you can 3 formats, make sure your first two are the
other numerical conditions you mentioned below and for the third make the
formula this:

=OR([cell]="OK",[cell]="Accept")
and then select your formatting

I have tested this out so if you have issues with this method please let me
know.
 
Back
Top