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

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

https://stackoverflow.com/questions/65896102/how-to-compare-2-excel-sheet-row-wise-where-order-of-data-is-not-fixed January 26, 2021 at 12:59PM