I have an excel file with 2 sheets. There are 10 columns in each sheet. Columns in Sheet 1 and Sheet 2 are the same but the data is slightly different.
Is it possible to compare the 2 sheets and highlight the rows or cells with a difference? Is it possible to reach to a solution without a VBA or vbscript? Is it possible to reach to a solution using vlookup or match or conditional formatting?
Thanks in advance.