Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Menu
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Menu
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Menu
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Menu
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit Menu will not automatically drop down anymore | Excel Discussion (Misc queries) | |||
Excel 2003 - Certain icons in drop down menu are not functioning | Excel Discussion (Misc queries) | |||
hyperlinks in drop down menu | Excel Worksheet Functions | |||
hyperlinks in drop down menu | Excel Worksheet Functions | |||
How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) |