View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Conditional Format text Excel 2003

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

If this post helps click Yes
---------------
Jacob Skaria


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