After a selection is made from the DV dropdown you can color the selection
using CF.

But.........the individual entries cannot be colored within the dropdown.


Gord Dibben MS Excel MVP


On Sat, 19 Sep 2009 09:49:01 -0700, Tami
wrote:

i know this is a long shot but i thought i'd try asking...

I have a spread sheet that has the validation drop down box pointing to a
list in column A.

column A contains a bunch of 2 digit codes: 01, 02, 03 etc. Is there a way
that the drop down box shows that 01 is black, 02 is green, 03 is blue, etc?