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't be done.


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

"GKapp" <(E-Mail Removed)> wrote in message
news902EEE3-6B7F-4752-BE2F-(E-Mail Removed)...
> 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.

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 <(E-Mail Removed)>
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.