Conditional Formatting based on other cells

U

userzero

How do I execute this example:

If Cell A1 has the value "OK" or "YES" or "MAYBE", then turn all the
cells in range A2:A10 black.

I don't want to put a formula into cells A2:A10 because I need the user
to enter data into the black colored cells. This would overwrite any
formula that was sitting in that range of cells.

Thanks,
M
 
B

Bob Phillips

Use conditional formatting, Format>Conditional Formatting,. with a formula
of

=OR(A1="OK",A1="YES",A1="MAYBE")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
T

tiab86

Go to your Conditional Formatting Menu.
Select Cells A2:A10
Put into Condition 1 the following:
Select "Formula Is" type in the formula=A1="OK", set Format Border to
Black
Use the same for Yes and Maybe.
 
T

tiab86

Thanks Bob,

I've been trying to figure that one out.
I have been able to learn some of the tricks to Excel formulas but
Conditional Formatting has been harder to figure out.

Thanks
 
S

Sloth

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