Drop Down list..

[Shabazz1999]

I'm pretty new to excel.

How do I get differents fonts, text size, colours in a drop down list box
selection.

If I have a list...and I want one selection to come up as Blue and another
as red. How do I do it.

Please help.

 

[Wigi]

Hi

The only way I know of, would be as programmed by Andy Pope:

http://www.andypope.info/vba/colourdropdown.htm

Although this will be way too difficult if you're new to Excel (written with
dignity). Search the newsgroups if you would be stuck somewhere.

 

[challa prabhu]

Hi,

For more information, please refer to this link:

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

and then at the end of "xlDataVal01.html" page there are more links that
would assist you with more information.

Challa Prabhu