How to Compare 2 excel sheet row wise where order of data is not fixed

Question

Comparing 2 excel sheets where we need to find id and match next column and if difference then highlight the difference cell. eg;

 Sheet 1
 123412 Bob   Y
 112234 Jill  Y
 998822 Carry Blank

 Sheet 2
 112234 Jill  XX
 998822 Carry Blank
 123412 Jack  ZZ

Here sheet 2, 123412 has different data in col2 and col4 Also, Sheet 2, 112234 has different data in Col3 when compared with sheet1 I need to highlight the cells so that difference can be identified easily. There is huge amount of data.

Highlight, Sheet2- Jack, ZZ and XX cells and Sheet1 - Bob, Y, Y(of Jill)

question from:https://stackoverflow.com/questions/65896102/how-to-compare-2-excel-sheet-row-wise-where-order-of-data-is-not-fixed

Answer 1

Waitting for answers