Hi, Is there a way to highlight duplicates on the same row within two columns? I have two columns each containing the same data and that data is the same multiple times within each column so I'm only looking to highlight if the data is the same in both columns in a row. Example
Column A Column B
1 7
2 4
5 8
7 7 - Highlight this row
5 3
5 1
4 4 - Highlight this row
4 9
I don't want to highlight duplicates in rows, I can do that, I only need if they match in the row
Thanks in advance
Bookmarks