If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|