I want to change the background of a cell as long as the running total in that column from start to that cell is less than a limit specified in a different cell.
Conceptually, the formula should look like this:
or, in more concrete terms:
For example, suppose the value in cell
19, and column
C looks like this (starting from C6):
10 5 3 2 1
Now, for illustrative purposes, let's compute the running total for each cell in the column (note that this column does not actually exist in the spreadsheet):
10 15 18 20 21
Remember, I want to change the background if the running total is less than the specified limit. So, for this example, the first 3 cells should have their backgrounds changed.
My problem is that I don't know how to write the reference for THIS_CELL. This is what I've tried so far:
...but I get this error:
Any suggestions on how I can make this work the way I want, or is that error message indicating that it's impossible? I know I could cheat by adding a "running total" column and configure conditional formatting based on those results, but I want to avoid that if at all possible.