Compare 2 excel spreadsheets and highlight the differences
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?
Select the first cell of Sheet 1 (A1) > Conditional Formatting > Use Formula:
This looks at Sheet1 cell A1 and if it is not the same as Sheet2 cell A1 then it will perform the formatting. Apply formatting of your choice (cell fill, text font, etc.) and apply to workbook.
Fill down formatting to all cells in that column. Rinse and repeat for each column, exchanging the $A1 for $B1, etc.
This applies formatting to Sheet 1 only, and will have to be repeated for Sheet 2 if you want to see highlighting there as well.