I have a question. I am trying to do conditional formatting and seem to have come to a block.. Currently using 2007 excel.

I have columns with percentages and numbers, i need to find the highest value in the column and colour the other values in the range,
E.g
6.6% 4.1% 11.8% 11.3% 5.0%

The max at 11.3%

100%-85% of Max should be green
85%-75% of max should be light green
75%-50% of max Should be orange
50%-0% of max should be red

How would i go and do this?