Comparing Two Excel Sheets For Changes. Then go to the task bar to display the new window of the current workbook. This is the option for excel 2016 (you can do this in excel 2010 and 2013, but the ribbon option is different).
Download excel file compare and merge tool to compare excel worksheets for differences and merge changes. Open the two workbook files you want to compare in excel. Choose the option titled use a formula to determine which cells to format.