| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
why don't i get colour in my drop down menu
When creating a drop down menu in excel the colour fonts from my selection
lists are not transferred to my menu? can you help? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
why don't i get colour in my drop down menu
How have you created the drop down list? Is this Data Validation, a list or
combo box, from the Control Toolbox or the Forms Toolbar? And since you say menu, do you really mean you have customized Excel's menu system? FYI - data validation lists will not display the format of the cells in the list range. However, you could write a macro or use condtional formatting depending on the number of colors you are using and your version of Excel. However, the color will not show in the drop down list but it could show in the cell after you pick an item. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Tim" wrote: When creating a drop down menu in excel the colour fonts from my selection lists are not transferred to my menu? can you help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down choice needs to lead to another drop down menu | Excel Discussion (Misc queries) | |||
| Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
| filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
| How do I create a drop down cell menu with different colour cells | Excel Worksheet Functions | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
Hybrid Mode
