Hello,

I have been looking for a way to sum cells until they reach a target number. For example

C10 123
C11 158
C12 202
C13 245
C14 114
C15 145
C16 157
C17 178
C18 187

C52 450


Cell C52 is variable based on other factors, currently set to 450, I want it to add the above numbers until it reaches or exceeds C52 value, highlight the cells and then continue adding again until it hits or exceeds C52 value etc. until it reaches the end of the cell range.

So in the above example, it would highlight 123/158/202 and then start again until it hit anoher grouping that exceeded 450 and then color it differently and so on.

Any help would be appreciated

Thanks,

Mike