Comparing multiple rows with multiple details from one sheet to another.

[cytochrome]

Hi here,
Need some help on an issue.
I have 2 spreadsheets, both have the same type of information. (Account Number/Transaction Number/Amount/Reference).
Is there macro that can look at each row on the first sheet, then find that on the entire second sheet. If all 4 details matched, then highlight that row on sheet1 and sheet2. If there is something on sheet1 and not on sheet2 and vice versa, then don't highlight those rows.
Hope that makes sense and thank you ahead for your help.

 

[bebo021999]

Not too difficult, if you could upload an image/XL2BB or gg drive link, to help us to see what the sheets look like

 

[cytochrome]

Pls see sample pics. The 2nd row in Sheet1 is the same as the last row on Sheet2, hence both are highlighted.

 

[bebo021999]

It could be done with conditional formating.
Like this:
=COUNTIFS(SHEET2!$A:$A,$A1,SHEET2!$B:$B,$B1,SHEET2!$C:$C,$C1,SHEET2!$D:$D,$D1)>0

 

[cytochrome]

Thanks. May be I'm new to this but where iwould I put in this formula? On sheet1 or sheet2? Or how can I get the rows to highlight?
Also, if I can get a macro it would be more efficient since the next time I compare another 2 sheets I don't have to retype.