Thread: Highlight a sorted cumulative range

OK, what i'm trying to do is auto-highlight green and bold percentages that equal, counting highest to lowest, 80% of the total.

I thought there would be a conditional format that would work but it looks like that only looks at top or bottom x percentile which is not what i need.

in other word, if i had the following numbers:
5%, 20%, 2%, 20%, 10%, 3%, 20%, 20% what i would want is all the 20%s to be green and bold.

this would need to be looked at on a row by row basis.

Any help is appreciated.

i was just picking random numbers to illustrate, the %s will likely not be so obvious. if that makes sense.

Hi Juniperjacobs,
I'm new at this and it's my first try, but here's an idea for you to try.
First sort your numbers, high to low. Then, using the conditional formatting you spoke of, go in and use this formula (or one similar I reckon) to determine which values are true and the set your formatting for green fill and bold font. The code is:

 =IF(SUM($H$1:$H1)<=SUM($H$1:$H$8)*0.8,TRUE,FALSE)

Hope that helps. If not, well, sorry, rookies like myself have to start somewhere.
GSM

this would be awesome, and thanks for the response. but i should mention, the data will not be in a position to be sorted. it's organized by a different parameter that cannot be changed. so i need a solution that doesn't involve sorting.

but thank you!