How do I color code items in a drop down list?
 

I have a range of options in a drop down lists that I want to appear in color
when selected.

You can't colour the items in the list, but you could use conditional
formatting (for up to three conditions) to colour the text in the cell,
after an item has been selected. There are instructions he

http://www.contextures.com/xlCondFormat01.html

Beckers1986 wrote:
I have a range of options in a drop down lists that I want to appear in color
when selected.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html