Hi,

I am trying to write some code that will colour shapes on the basis of a cell value. I have a column of shape names and beside them I have a column of 1s and 0s. I want the shape to change to green if the value is 0 and white if it is 1. I know how to do a line by line check to see if the value is 0 or 1 and then go and change the colour of that shape but I have a feeling there is a more elegant way to do this using named ranges and/or vlookup in VBA. Anyone have any suggestions?