How can I use conditional formating in dropdown using named list?

K

Kiwi

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.
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Automatic change content of a cell in table using dropdown list 5
Dropdown with signatures 1
Conditional List dropdowns? 1
how to add a combolist drop down to each row 2
Duplicate hashtags in OneNote 0
How to populate other fields when a dropdown was changed 13
Best way to display Mulitple comboboxes and dropdown boxes for a userform 0
Displaying arrow in a dropdown list within cell 2

Top