How do I use different colours in drop down menus in Excel 2003?

  • Thread starter Thread starter mbdixon
  • Start date Start date
M

mbdixon

In a spreadsheet I'm using the Validation Data tool to create a drop down
menu for cells but all the background colour is white no matter how I shade
the source cells. Is it possible to shade the cells in the drop down menu?

Regards
Mark
 
I don't think so.
In a spreadsheet I'm using the Validation Data tool to create a drop down
menu for cells but all the background colour is white no matter how I shade
the source cells. Is it possible to shade the cells in the drop down menu?

Regards
Mark
Click to expand...
 
No it is not possible to shade the values in a data validation drop down.
Even in a Combo box that is not possible (you can choose only one colour for
all of the entries).
 
That will color the cell only after a selection is made from the list.

The items in the list itself cannot be colored.


Gord Dibben MS Excel MVP
 
Back
Top