Formula

[JulieB225]

I have data on 2 sheets in the same workbook. I want to compare 3 specific rows for matches. If all 3 rows match each other, I want to highlight them. How do I do this?

[#2]

@JulieB225 

So assuming you have two sheets called Sheet1 and Sheet2 and you want to compare the Sheet1!Row2 with Sheet2Row3 and Sheet2!Row5, you may try the following formula to make a new rule for conditional formatting.

=AND(CONCAT(Sheet1!$2:$2)=CONCAT(Sheet2!$3:$3),CONCAT(Sheet1!$2:$2)=CONCAT(Sheet2!$5:$5))