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