DropDown Menu Macro
 

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

DropDown Menu Macro
 

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

DropDown Menu Macro
 

I'm being a bit of a donkey, could u right the whole formula i need to
enter?


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

DropDown Menu Macro
 

I did.

It is working fine for me with B10. for C12:F12, the formula would be

=$B$12<""



--
Regards,
Tom Ogilvy


"alex1982" wrote:


I'm being a bit of a donkey, could u right the whole formula i need to
enter?


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