Color row until the sum of cell is equal to a certain value

by Tommaso   Last Updated August 14, 2019 10:01 AM - source

Good day everyone, I need to dynamically color rows of a table, until the sum of cells of a column reachs a certain value


The "Effort" column is column E. I need therefore need to color rows until the sum of column E value is 240. In this case, assuming that "Feature O" cell is in row 4, I would need to color until row 14 "Feature E" excluded. This table is subject to changes, as new rows might be added, or effort recalculated.

I hope it is clear enough so that you can help me.

Cheers. Tommaso

Related Questions

Select 1st day of each user id in excel

Updated December 19, 2018 07:01 AM

Text function in Excel isn't formatting year

Updated February 07, 2019 07:01 AM