Conditional Formatting based on other cells

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

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)

"userzero" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> userzero
> ------------------------------------------------------------------------
> userzero's Profile:
http://www.excelforum.com/member.php...o&userid=33246
> View this thread: http://www.excelforum.com/showthread...hreadid=530707
>

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.

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

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