Drop Down Menu

[alex1982]

I have created a drop down menu in say A1, when one of the selections is selected i have a conditional format set up to change the background colours of cells B2-G2. Is it possible to clear the text from these cells too?

[Bob Phillips]

You could make the font colour the same as the fill colour, it won't clear
the text, but it will look like it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"alex1982" <[email protected]> wrote in
message news:[email protected]...
>
> I have created a drop down menu in say A1, when one of the selections is
> selected i have a conditional format set up to change the background
> colours of cells B2-G2. Is it possible to clear the text from these
> cells too?
>
>
> --
> alex1982
> ------------------------------------------------------------------------
> alex1982's Profile:
http://www.excelforum.com/member.php...o&userid=37494
> View this thread: http://www.excelforum.com/showthread...hreadid=572589
>

[alex1982]

I have tried that before, was just wondering if there was another way of doing it.

[Dave F]

Well you could record a macro and run that macro as necessary.

Not sure how familiar you are with those, though.

"alex1982" wrote:

>
> I have tried that before, was just wondering if there was another way of
> doing it.
>
>
> --
> alex1982
> ------------------------------------------------------------------------
> alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
> View this thread: http://www.excelforum.com/showthread...hreadid=572589
>
>