View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How can I use conditional formating in dropdown using named list?

Excel's data|validation, comboboxes, and dropdowns don't support this kind of
formatting.

Kiwi wrote:

I have a dropdown list that refers to column in another worksheet. I would
like the dropdown to display the text in the same formats as in the original
list. eg. Text in red displays red in the dropdown.
I'm using Excel 2003.


--

Dave Peterson