Highlight Sequential Cells That Sum Up To A Value

[Prabhu]

Why don't you try conditional formatting....

=SUM($K$2:$K2)<$L$1 dragged down till the last row

See attachment

Hi Admin,

This formula is considering from first cell till near by value.If the value is exceed the value then it shows as false.

Attached workbooks shows by applying this formula we can get the value of Rs.929383 but if we find manually we can get exact value of 10 L(Highlighted in Green).

So we need to check entire cells in the particular column and find out very near by value.

Is there any way to do so(By formula or Macro)?

Plz help.