How To Compare 2 Worksheets In Excel. Click the home tab, select conditional formatting, and add. Under the view tab, select the view.
If the needed worksheet is not. In the list of open books, select the sheets you are going to compare. Web select the sheets from the first workbook that you want to compare and select add to move those sheets to the compare these worksheets field.