Check The Difference Between Two Excel Files. This is similar to the method above where we used the equal to operator with one added advantage. In the Compare field click the drop down arrow to select the first workbook you wish to compare.
In the Compare field click the drop down arrow to select the first workbook you wish to compare. 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. Highlight differences between two sheets in the same workbook With the Conditional Formatting utility you can highlight the differences between two sheets in the same workbook.
Open the workbook that has the sheets that you want to compare.
Oct 09 2020 Now in the Home Tab click on to the Conditional Formatting and Under Highlight Cells Rules click on to Duplicate Values. Select New Window to open the same workbook in a new Excel window in the background. Then you can use Compareworkbook macro to compare two excel files. This is similar to the method above where we used the equal to operator with one added advantage.
