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.
Gents, your answer are very much appreciated. Assuming now that I have a pool of resources available for a certain release. I need to color green up to a certain value, then, from there, need to color until another value is reached (a delta), and so on. enter image description here
What I want to reach is to show how many items fits in a certain pool of resources, with the value on coloum K
I've tried the following, but after the green color, the formula is not correct: while the pool for the 2nd release is 153.6, the formatting colors the cells up to 168, instead of 153.6
I hope it's clear,