as an example, select C10:F10 then do

Format=conditional formatting

change the cell value is to formula is and write a formula like



=$B$10<""

then select formatting and select pattern and grey

--
Regards,
Tom Ogilvy



"alex1982" wrote:


Does anyone know how to create a macro to do the following:

drop down menu

when nothing selected the following 4 cells appear clear, when one of
the two options selected the following 4 cells appear grey.

Please see attached file


+-------------------------------------------------------------------+
|Filename: Image1.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=5193 |
+-------------------------------------------------------------------+

--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=571488