I have a range of options in a drop down lists that I want to appear in color when selected.
B Beckers1986 Jan 23, 2005 #1 I have a range of options in a drop down lists that I want to appear in color when selected.
D Debra Dalgleish Jan 23, 2005 #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 here: http://www.contextures.com/xlCondFormat01.html
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 here: http://www.contextures.com/xlCondFormat01.html