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