Tip Printed from ExcelTip.com

---

Selecting/Formatting Cells Containing Errors


Selecting cells containing errors is important for fixing, coloring or deleting of those cells.

Option 1: Using the Go To dialog box:

1. Press F5.
OR
From the Edit menu, select Go To.
2. In the Go To dialog box, click Special.
3. Select Formulas, and Errors, and then click OK.

Option 2: Using Conditional Formatting to format cells containing errors:

1. Press Ctrl+A to select all cells in the active sheet, in Excel 2003 press Ctrl+A+A from a cell in a region.
2. From the Format menu, select Conditional Formatting.
3. In Condition 1, select Formula Is.
4. In the formula box, type the formula =ISERROR(A1).
5. Click Format, select the desired format, and then click OK.