excel 2003 drop-down box color changes how
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? |
excel 2003 drop-down box color changes how
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? |
excel 2003 drop-down box color changes how
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? |
All times are GMT +1. The time now is 02:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com