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


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

Conditional Formatting based on other cells
 

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

Conditional Formatting based on other cells
 

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

Conditional Formatting based on other cells
 

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

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