I would like to compare 2 rows in the attached spreadsheet and highlight where there are differences between the columns, using the 1st row as the "master". I also attached my spreadsheet as there are more than 7 columns of data.
I would like a vb solution to compare the rows.
Col 1 Col2 Col3 Col4 Col5 Col6 Col7
Row1 (Q 1111 1 23 Y N F
Row2 (Q 1111 1 23 N N U
Row3 :1 1111 2 22 Y Y F
Row4 :1 1111 3 22 Y N F
Row5 :1 1111 2 23 Y Y F
I would like the below columns highlighted as differences. (using column 1 as the "join")
Row2 col5, col7
Row4 col3, col6
Thanks in advance for your assistance.