Can I have assorted colors on list in a drop down box in Excel?
 

I'd like to have each word in the drop down box be a different color, and
although I've done that in the source cells, it doesn't carry over when
chosen.

Can I have assorted colors on list in a drop down box in Excel?
 

Can't be done.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"GKapp" wrote in message
...
I'd like to have each word in the drop down box be a different color, and
although I've done that in the source cells, it doesn't carry over when
chosen.

Can I have assorted colors on list in a drop down box in Excel?
 

Cannot be done assuming you are using a Data Validation dropdown.


Gord Dibben MS Excel MVP

On Fri, 14 Sep 2007 13:42:04 -0700, GKapp
wrote:

I'd like to have each word in the drop down box be a different color, and
although I've done that in the source cells, it doesn't carry over when
chosen.