Need a few changes in that if you could please help.
Attaching the file with the coding.

The macro use to match the same amounts with the same reference and turn it to Green. (eg. 50 Credit with 50 Debit both with reference say 7896) - SHEET 1

I just need one more thing added to this the coding ( One more Colum will be added called source -SHEET 2 )
If both the amounts match with same reference but if the source is BANK for both they should not turn Green)

Sheet one is working macro.
Sheet 2 is the one in which i need changesMatch Macro.xlsm.

I hope i have not made it confusing, waiting for ur reply.
Thanks for your support guys, really appreciate it.

Kartikeya Dawar