Highlight Sequential Cells That Sum Up To A Value

[Prabhu]

Hi Firend,

I need macro which has to highlight cells in the particular column up to the extent of the given value.

The excel sheet has around the 30-50 K rows many columns with value.

If I want to pick up the value cell which is equal to 10 laksh then it should highlight the cells which total comes to 10 lakhs.

In case sum of the cells not come exactly to 10 laksh then it should show very near to 10 lakhs.

I have attached the sample date for your reference.

Plz do the needful.

Prabhu.