compare excel worksheets for differences

In the formula, B4is the first cell of the compared ranges. 2.3) Click the Format button to specify a highlight color for the differences.2.2) Enter the below formula into the Format values where this formula is true box.2.1) Select Use a formula to determine which cells to format option in the Select a Rule Type dialog.In the New Formatting Rule dialog box, you need to: Select the whole table in the worksheet that you will highlight different value cells in it (in this case, I select table 1 in Sheet1), and then enable the Conditional Formatting function by clicking Conditional Formatting > New Rule under the Home tab. Download and try it now! (īesides, you can highlight all cells that have different values in two worksheets by using the Excel build-in function - Conditional Formatting.ġ. It is optional to highlight the different cells by adding background color or font color as the below demo shown. All differences will be selected automatically after comparing.

The Select Same & Different Cells utility of Kutools for Excel can help you to easily compare two worksheets for differences in a workbook or different workbooks. Keep selecting cell C2, drag the fill handle to the right cell and then drag down to list all compared results.Įasily compare two sheets for differences in an Excel file or two Excel files: Create a new sheet to placing the compared result, select a blank cell (here I select cell B5) in the new sheet, copy and paste the below formula into it and press the Enter key. For comparing the sales columns for differences between these two sheets and listing the compared result in a new sheet, please do as follows.ġ. Supposing you have two spreadsheets in an Excel file as below screenshot shown. Highlight differences between two worksheets with Conditional FormattingĮasily compare two sheets for differences in an Excel file or two Excel filesĬompare two worksheets for differences in the same workbook with formula Please browse for more details.Ĭompare two worksheets for differences in an Excel file with formula How to compare two worksheets in a workbook or two workbooks for differences in Excel?Īs the below screenshot shown, have you ever tried to compare two worksheets for differences in Excel? This article is going to show you methods of comparing two spreadsheets for differences in the same Excel file or different Excel files in Excel.

Compare excel worksheets for differences