Debra
Maybe I jumped to the conclusion that the op wanted the end result of the
selection to be colored. If that were the case couldn't they just format the
cell. I guess I don't see the value in coloring the list unless one wanted
the display to be that color. If that be the case formate the cell! Any
input (education) would be appreicated. And Debra, thanks for the reply
through anothers thread...

Mike R.

"Debra Dalgleish" wrote:

Mike,

I'm not quite sure what you're asking. If the data validation list is
High, Medium, Low, you could use conditional formatting to colour the
cell after one of the items is selected. High could be red, Medium could
be yellow, and Low could be green.

However, three is the maximum number of conditions for conditional
formatting. So, if your list has more than three items, you'd need a
different method of automatically colouring the cell based on the
selected item. You could use an event procedure to apply a colour
programmatically.

Debra


Mike R wrote:
Debra
There must be a reason for not just formating the cell for the color
desired. I am assuming that it must be to combersom. Am I right? There must
be more here to see than I am able.

Mike R.

"Debra Dalgleish" wrote:


You can't format the items in a data validation dropdown list. You could
use conditional formatting to colour the cell, if there are only three
options. For more than three, you'd need to use programming to format
the cells.


RobShep wrote:

how do I change the colour of the text in a drop box list I have created
Can I also change the colour of the cell fro different words in the list


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





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