Conditional formating cells that add up to % of total

[Peter h]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Initial Weight
[/TD]
[TD]Sieve 1
[/TD]
[TD]Sieve 2
[/TD]
[TD]Sieve 3
[/TD]
[TD]Sieve 4
[/TD]
[TD]Sieve 5
[/TD]
[TD]Pan
[/TD]
[/TR]
[TR]
[TD]100 g
[/TD]
[TD]2
[/TD]
[TD]15
[/TD]
[TD]20
[/TD]
[TD]25
[/TD]
[TD]15
[/TD]
[TD]23
[/TD]
[/TR]
</tbody>[/TABLE]

I would've googled this, but I'm not exactly sure how to word it. What I'd like to do is do conditional formatting for cells that add up to 90% of the total sum of cells in the range. Not sure how to approach this. Here is an example of my data.

I'm doing Sieve analysis at work, and want to be able to see at which point 90% of my sample is making it through the sieve. So, in my example table, the data for Sieve 2 would be the highlighted cell, because adding the data backwards starting with the "Pan" column, I don't add up to 90% until I add Sieve 2.

 

[Peter h]

I got it figured out. If anyone else is interested. In the conditional formatting putting the formula "=SUM(A2:$G2)>=$A1*.9" and it formats it exactly how I want it.