DropDown Menu Macro

  • Thread starter Thread starter alex1982
  • Start date Start date
A

alex1982

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 |
+-------------------------------------------------------------------+
 
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
 
Back
Top