How to creat a dropdown list with format
 

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

How to creat a dropdown list with format
 

If you only have 4 numbers in your list you could use conditional format to
change the colour

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200808/1

How to creat a dropdown list with format
 

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