Microsoft Excel 2007 with Example

5 Find & Select

5.3 Find & Select : 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.

Data in Excel

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...

Click Go To Special

3. Select Row differences and click OK.

Select Row differences

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.

Cells Whose Contents Are Different

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

Change Background Color