DropDown Menu Macro

[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

[Tom Ogilvy]

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
>
>

[alex1982]

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

[Tom Ogilvy]

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
>
>