Matching Macro

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

Hey, thanks for your quick response, just one thing more i would like to ask when ever the new reference column has a Blank or any alphabet the macro dosen't work..?

Please advice

Thanks Once again

Dint really understand ??

MatchMacro.xlsm

Hey, attaching the sheet error comes on sheet 2.

Thanks for your help.