Thank you that works well.
--
mfg41


"Debra Dalgleish" wrote:

No, you can't format the items in a data validation dropdown list.

You could use conditional formatting to change the colour in the cell,
after an item has been selected.

There are instructions here for conditional formatting:

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

mfg wrote:
I have a drop down list with 3 items in it. My question is I want each item
to show in a different colour is this possible and if so how do I acomplish
this.


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