why don't i get colour in my drop down menu

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

When creating a drop down menu in excel the colour fonts from my selection
lists are not transferred to my menu? can you help?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down menu formatting 2
Drop down menu 2
Drop Down list with colours 1
Conditional Drop Downs 3
Filling colour in drop down options 1
Drop Down Menu 2
Does Excel Support Drop-Down Menus to Select Information? 14
Chart Title change with Drop Down Selection 2

Back
Top