Hello:
Please refer to attached file.
I need either VB Code or conditional formatting WHICH I PREFER to perform following task.
This is to reconcile bank Statements.
Column I thru K shows each day sales for that day which got depostid in the bank.
The date in column I is the date of the sales and it is not the deposit date.
Column F shows the date of deposit in the bank for the amount shown in column D.
I need to make sure that the Sales recorded in column K are deposited in the bank.
To visually see this, i have come across following logic.
I have added 5 days grace period in column M to make the deposit for a day.
So i am now assuming that owner as me will make the sales deposit for 1/1/2016 by 1/6/2016, 1/2/2016 by 1/7/2016 and so on.
Now I would need VB Code or CF to comapre value in column K between dates in column I and M in Column D for date in column F
Once amount is found then highlight the value in column D and Column K with GREEN.
Example :
Lets look at K2 = 410 between 1/1/2016 and 1/6/2016.
Look up 410 between 1/1/2016 and 1/6/2016 in column D.
We see 410 on 1/4/2016 in cell D2 so highlight D2 and K2
Lets look at K3 = 490 between 1/2/2016 and 1/7/2016.
Look up 490 between 1/2/2016 and 1/7/2016 in column D.
We see 490 on 1/4/2016 in cell D4, so highlight D4 and K3
and so on....
Let me know if you have any questions.
Thanks.
Riz
Bookmarks