Excel Spreadsheet - Formatting Dropdown lists
 

I have set-up a drop down list on a separate worksheet which contains items
formatted in different fonts (red, blue, green, etc). When I reference the
the drop-down list the items are in black font only. How do I retain the
different fonts in the list? Any help would be
appreciated.......................

Sorry, you can't do this with a simple formula.
I expect if you put the question on the programming newsgroup you will get
someone telling you the code for a VBA subroutine to do this.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Formatting of drop down lists" <Formatting of drop down
wrote in message
...
I have set-up a drop down list on a separate worksheet which contains items
formatted in different fonts (red, blue, green, etc). When I reference the
the drop-down list the items are in black font only. How do I retain the
different fonts in the list? Any help would be
appreciated.......................