Colour coded drop down list

A

AlFinsberg

Help! I have build a DV drop down list but I want the different options to be
colour coded. I have coour-filled the original cells but this formatting does
not carry over to the drop down list.

Anyone know how to do this?
 
C

Chip Pearson

You cannot change the color of the individual elements in a dropdown.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
R

Roger Govier

Hi

You cannot do this. Regardless of the font or fill colours in the source
list, they will always appear as Automatic on No Fill in the DV dropdown.
You could use VBA to colour the resulting selection the same as the origin
in the list, but that would be post the event i.e. after the user had
selected from the monochrome list.
 

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

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Drop down lists in seperate columns 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Link a text box based on drop down box with four options MS Word 365 0
Font drop-down menu very slow 0
Change the colour of a neighbouring cell 6
MS Project Center-Autolink column fields 0

Top