I'm not sure that is possible with a dropdown list on a worksheet. Andy Pope
created VBA code (with a downloadable demo workbook) to color the items in a
dropdown list on a userform. Maybe the code is adaptable for a worksheet
control. Here is a link:
http://www.andypope.info/vba/colourdropdown.htm

Hope this helps,

Hutch

"Na$" wrote:

hi,
I managed to create a dropdown list, but I'd like it to pick the format of
the original field. ie: font, collor, etc,etc... is this possible?
In my case, I have a list of numbers from 1 - 4 and each one has one color,
so I'd like when I pick a number it comes with its color, and it's coming
just the number...

thanks--
Malange, Angola