HELP - Conditional formatting for ABC curve

**sanvejar** · 10-12-2015, 10:08 AM

Hi folks.
Really need a hand with this issue:
I need to highlight top values (in a seri that sum up to 80% of the total value (if the sums goes under 80%, it should also highlight the next top value)
For instance:

Value:
35%
2%
4%
5%
6%
7%
18%
23%

So in this case I should highlight the following numbers: 35%; 23%; 18%; 7% (equal 83%)

Any clue on how formatting this??

HELP please

**Special-K** · 10-12-2015, 10:40 AM

Maybe use the Solver Add-In with Conditional Formatting?
I've never used Solver before so you'll have to wait till someone comes along and verifies that my solution could work.

**MrShorty** · 10-12-2015, 11:00 AM

Are you allowed to sort the numbers? If the numbers were sorted from largest to smallest, this could easily be a simple running sum [=sum(a$2:a2)] copied down (note the use of absolute and relative referencing to make it easy to copy), with a simple test [if(b2>=0.8,what to do if above 80%,what to do if below 80%)] should work well.