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

Use conditional formatting, FormatConditional 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" wrote in
message ...

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.


--
tiab86
------------------------------------------------------------------------
tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628
View this thread: http://www.excelforum.com/showthread...hreadid=530707

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


--
tiab86
------------------------------------------------------------------------
tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628
View this thread: http://www.excelforum.com/showthread...hreadid=530707

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