Row Differences

This example teaches you how to quickly highlight cells whose contents are different from the comparison cell in each row.

1. To select the range A1:C15, click on cell A1 and drag it to cell C15.

Note: because we selected the range A1:C15 by clicking on cell A1 first, cell A1 is the active cell (Use ENTER and TAB to change the active cell). As a result, the comparison cells are in column A.

2. On the Home tab, click Find & Select, Go To Special...

3. Select Row differences and click OK.

For row 2, Excel selects cell B2 because 523 is not equal to the value in cell A2 (522). For row 4, Excel selects cell B4 and cell C4 because 725 is not equal to the value in cell A4 (723), etc.

4. On the Home tab, in the Font group, change the background color of the selected cells.