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

I am trying to create a drop down list with format 1
use color coded data on a drop down validated list 1
Using coloured text within a Validation List 1
Filling colour in drop down options 1
Filtered drop down list 2
Data Validation - Cell Colour 3
copy contents including colour 3
How do I get drop down menu's to show different background colour 3

Top