kutta
Footballguy
I am somewhat Excel literate, but by no means am I an expert. So, here's what I need to do.
I have a bunch of rows of data for projected projects in 2017. The last column in the rows is "2017 Revenue." The rows are sorted so that the biggest number in "2017 Revenue" is first, followed by the next biggest, etc. There are maybe 40 rows of data, with the last row being "Total 2017 Revenue" which sums the "2017 Revenue" column. Simple enough.
What I would like to do is color code the rows that make up 80% of the 2017 revenue. So let's say the Total 2017 Revenue is $20M, I would like to color code the rows, starting at the top (highest value project) until I get to a total amount of $16M ($20M * 0.80). So if the first six projects total 80% of the total, I would color code the first six rows.
Any thoughts on the best way to do this?
TIA
I have a bunch of rows of data for projected projects in 2017. The last column in the rows is "2017 Revenue." The rows are sorted so that the biggest number in "2017 Revenue" is first, followed by the next biggest, etc. There are maybe 40 rows of data, with the last row being "Total 2017 Revenue" which sums the "2017 Revenue" column. Simple enough.
What I would like to do is color code the rows that make up 80% of the 2017 revenue. So let's say the Total 2017 Revenue is $20M, I would like to color code the rows, starting at the top (highest value project) until I get to a total amount of $16M ($20M * 0.80). So if the first six projects total 80% of the total, I would color code the first six rows.
Any thoughts on the best way to do this?
TIA