Hello,

I can not figure out what i am doing wrong with this...Please help.

I am trying to create a dashboard with Shapes that automatically adjust
based on the results of a field. Meaning..if the results are between 0 and
5% the color of the shape should be Green. If between 5 and 10% then
Oranage.

I went to a number of sites and found this reference which is exactly what i
am looking for. I have set up a spreadsheet based on these instructions and
it all seemed to work great. However, there is one problem. The results
(the colors in the shapes) are not lining up to the results.

The event is being triggered correctly, but it is returning the wrong
results in terms of colors.

I have a worksheet that mimics the example from the website below..i am
happy to send it along.

As always...very appreciative of any help.


http://www.tushar-mehta.com/excel/ch...e%20colors.htm