Excel Spreadsheet - Formatting Dropdown lists

[Formatting of drop down 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.......................

 

[Bernard Liengme]

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
[email protected]> wrote in message
news:[email protected]...