Thread: color
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default color

You can't colour code the items in a data validation drop down list. You
could use conditional formatting to colour the cells or the font after
an item is selected.

There are instructions here for conditional formatting:

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

Kay wrote:
Is there a way to color code an already existing drop down list?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com