How can I color fill my drop down box for each individual text?
 

I'm looking to have the text items in my drop down list set apart from each
other and thought of color filling them individually. I can't find any way
to do that and wondered if anyone knew how

How can I color fill my drop down box for each individual text?
 

You can't format the items in a listbox individually.


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




"Chrisj1511" wrote in message
...
I'm looking to have the text items in my drop down list set apart from
each
other and thought of color filling them individually. I can't find any
way
to do that and wondered if anyone knew how