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