Sum numbers and change cell color each time a target total is reached

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

Another approach is to use a helper column to do the additions, and then use conditional formatting to indicate the last cell of each group.

This doesn't let you assign a different colour to each group, but if you use an underline instead, then it still indicates the different groups. I've attached an example.