Drop down list
 

I have a drop down list with 3 items in it. My question is I want each item
to show in a different colour is this possible and if so how do I acomplish
this.
--
mfg41

Drop down list
 

No, you can't format the items in a data validation dropdown list.

You could use conditional formatting to change the colour in the cell,
after an item has been selected.

There are instructions here for conditional formatting:

http://www.contextures.com/xlCondFormat01.html

mfg wrote:
I have a drop down list with 3 items in it. My question is I want each item
to show in a different colour is this possible and if so how do I acomplish
this.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Drop down list
 

Thank you that works well.
--
mfg41


"Debra Dalgleish" wrote:

No, you can't format the items in a data validation dropdown list.

You could use conditional formatting to change the colour in the cell,
after an item has been selected.

There are instructions here for conditional formatting:

http://www.contextures.com/xlCondFormat01.html

mfg wrote:
I have a drop down list with 3 items in it. My question is I want each item
to show in a different colour is this possible and if so how do I acomplish
this.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Drop down list
 

One scenario: You click on the drop-down arrow and the complete list is
displayed for you to pick from. You cannot have different colors for each
item.
Another scenario: You select one of the items. The list disappears and the
selected item is displayed in the cell. Using a WorkSheet_Change event
macro, that cell can display the color of your choice. Another selection
will produce another color of your choice. HTH Otto
"mfg" wrote in message
...
I have a drop down list with 3 items in it. My question is I want each item
to show in a different colour is this possible and if so how do I
acomplish
this.
--
mfg41

Drop down list
 

You can also use Conditional Formatting. Otto
"Otto Moehrbach" wrote in message
...
One scenario: You click on the drop-down arrow and the complete list is
displayed for you to pick from. You cannot have different colors for each
item.
Another scenario: You select one of the items. The list disappears and
the selected item is displayed in the cell. Using a WorkSheet_Change
event macro, that cell can display the color of your choice. Another
selection will produce another color of your choice. HTH Otto
"mfg" wrote in message
...
I have a drop down list with 3 items in it. My question is I want each
item
to show in a different colour is this possible and if so how do I
acomplish
this.
--
mfg41