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