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?