View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth
 
Posts: n/a
Default Conditional Formatting based on other cells

unless you want to enter them individually, you will need to enter the
formula with absolute references. Select A2 through A10 and click
format-conditional formatting. Select "formula is" instead of "cell value
is", and then enter this modified formula.

=OR($A$1="OK",$A$1="YES",$A$1="MAYBE")