Find Differences Between Excel Files. First select the ranges where you want to apply the conditional formatting. On the Inquire tab in the Compare group click Compare Files.
Select sheet 1 in the first window and sheet 2 in the second window. Click the blue folder icon next to the Compare box to browse to the location of the earlier version of your workbook. To highlight these differences leave them selected and click the paint bucket icon in the font menu and select the color you want to use.
In the Windows group click on the View Side by Side option.
In the lower-left pane choose the options you want included in the workbook comparison such as formulas cell formatting or macros. Or just Select All. Just select firstoriginal file in left window and secondmodified file in right window. Different Cells utility of Kutools for Excel can help you to easily compare two worksheets for differences in a workbook or different workbooks.
