Oct 17 2019 02:07 PM
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?
Oct 17 2019 09:29 PM
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))