View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sninkle Sninkle is offline
external usenet poster
 
Posts: 15
Default Conditional Format text Excel 2003

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.

"Rhonda" wrote:

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.