I have a group of cells that pull from a drop down list. I am currentl
using vba code that contains a Select Case statement to set the cel
background color based on what value is selected in that cell. This i
great except that the end user will not be able to just add to th
column that the drop down list pulls its value from without the result
for the new value only appearing with a white background. I want th
cells to lookup the their value in the column that contains th
validation list and change background to match the background of th
cell that it finds itself in. This way the end user could add a lis
item, set it's background color, and that would be the color used b
any cells matching that entry. Please Help!!

--
Message posted from http://www.ExcelForum.com