Auto-Identification of amount, in resp time interval column & coloring it, using VBA Macro

Hi Excel Experts,

Can any one, please help me with this..

I am having a excel spreadsheet, which contains CASH overdue, distributed as per days - diff. time interval.

Need help in first step - to identify them as per time interval.

I am finding the unallocated cash, mentioned in Column H, with the respective time Interval columns J - P & if identified, mark green in column Q same row & resp. identified cash/es, if not Orange in column H. (Which would be crosschecked manually later, after sort by color).

Two instances to identify: 1. Amount in Column H, Unallocated Cash; can have perfect match in one of the Time Interval columns- Then Identified.
2. Amount can be equal to sum of two or more cashes in Column J - P - Then its Identified.

Since, most of the cashes can be identified 75 + %, hoping for a VBA Macro code to do this task. Please help me with a VBA for the simple example provided in attached file, which consists 40 sample, actual work consists of 300+rows.

Please feel free to ask any info. leave a comment.

Thanks & Regards
Ram

Hi Ram_G

This Code identifies about 69% of the Offsets and appears to identify all that are in your Sample File. I'll need more examples to find the outliers.

I've not yet addressed the Results Sheet nor the Orange Colors (I'm terribly Color Blind...I assume Orange).

Please Login or Register  to view this content.

Hi Ram

Add the two indicated lines of Code

Please Login or Register  to view this content.