Excel 2007 : Conditional Formatting

**zarqa** · 05-18-2011, 07:44 AM

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?

**sweep** · 05-18-2011, 08:54 AM

Hi,

Use the following formulas

=A1>=0.85*MAX(A:A)
=AND(A1<0.85*MAX(A:A),A1>=0.75*MAX(A:A))
=AND(A1<0.75*MAX(A:A),A1>=0.5*MAX(A:A))
=AND(A1<0.5*MAX(A:A),LEN(A1)>0)

as per the attachment