Conditional Formating of Top 80%

**ashleybyrdnc** · 07-28-2009, 11:02 AM

I am trying to highlight the top 80% of products sold in a pivot table and when I use the rules of conditional formating it isn't working: Below is what I need to highlight. Any suggestions?

30.92% (Highlight in Red)
25.62% (Highlight in Red)
20.03% (Highlight in Red)
10.13% (Highlight in Red)
6.83%
2.32%
2.10%
2.05%
0.00%

**martindwilson** · 07-28-2009, 11:16 AM

with data in that order say it started in a1
=SUM($A1:A$9)>=20%

**ashleybyrdnc** · 07-28-2009, 11:34 AM

But I need it to add until it gets to 80% then stop

**martindwilson** · 07-28-2009, 11:38 AM

works with your example
dont forget as cf applied to the other cells it auto changes ref
so a2 would be
=SUM($A2:A$9)>=20%
a3
and a3 would be
=SUM($A3:A$9)>=20%
and so on