Conditional Format text Excel 2003

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

 

[Jacob Skaria]

=AND(condition1,condition2,OR(A1="OK",A1="Accept"))

If this post helps click Yes

 

[Sninkle]

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.