The data for the drop-down box is kept on another worksheet where each of the
items in the list not only have a name, but also have a different color
background.

When I use the drop-down box on the top sheet, all the names in the list
appear but the color of the cell does not.

Is there any way of bringing the color of the cell on the list worksheet
over to the top sheet when the drop-down box is used?

As far as I know, no.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"seasider" wrote:

The data for the drop-down box is kept on another worksheet where each of the
items in the list not only have a name, but also have a different color
background.

When I use the drop-down box on the top sheet, all the names in the list
appear but the color of the cell does not.

Is there any way of bringing the color of the cell on the list worksheet
over to the top sheet when the drop-down box is used?

The list items will not show in the source cells' color.

About the only thing you could do is color the cell when an item is selected.

You could use event code or see Bob Phillips' site for CFPlus add-in download.

Allows up to 30 conditions per cell.

http://www.xldynamic.com/source/xld.....Download.html

For event code......post back.


Gord Dibben MS Excel MVP

On Tue, 1 Jul 2008 04:41:03 -0700, seasider
wrote:

The data for the drop-down box is kept on another worksheet where each of the
items in the list not only have a name, but also have a different color
background.

When I use the drop-down box on the top sheet, all the names in the list
appear but the color of the cell does not.

Is there any way of bringing the color of the cell on the list worksheet
over to the top sheet when the drop-down box is used?