| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
| formatting drop down list | Excel Discussion (Misc queries) | |||
| How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
| edit a drop down list | Excel Discussion (Misc queries) | |||
| Drop dow list complication | Excel Discussion (Misc queries) | |||
Linear Mode
