I have a spreadsheet with two different versions. I need to determine what has changed.
What is the best (easiest) method?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Compare changes in two versions of the same spreadsheet
0
Answers
0
Select the entire used area of the second sheet, set conditional formatting to determine which cells to format by this formula:-
=A1<>Sheet1!A1Set a format like 'Fill' = yellow or 'Font' = red (just don't forget to set a format ;-).
The changed cells will be displayed with the format which you set.
In the above formula the first sheet is presumed to be named "Sheet1". Replace the name in the formula with the actual name of that sheet.
The formula also presumes that A1 is included in the selected range. If it isn't use the address of the top left cell of the selected range instead.