Formatting Text to Hide Errors in Excel Worksheets

There are many reasons why formulas can return errors. For example, division by 0 is not allowed, and if you enter the formula =1/0, it returns #DIV/0. Error values include #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.

Format text in cells that contain errors so that they don't show:
  1. Select the range of cells that contain the error value.

    Select the range of cells that contain the error value.
  2. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click MANAGER RULES.
    The Conditional Formatting Rules Manager dialog box is displayed.

    On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click MANAGER RULES.
  3. Click NEW RULE. The New Formatting Rule dialog box is displayed.

    Click NEW RULE. The New Formatting Rule dialog box is displayed.
  4. Under Select A Rule Type, click USE A FORMULA TO DETERMINE WHICH CELLS TO FORMAT.
  5. Under Edit the Rule Description, in the Format values where this formula is true list box, enter the following formula:
    =ISERROR (reference)
    ** Where reference is a relative reference to the cell that contains the error value.
  6. Click FORMAT, and then click the FONT tab.

    Click FORMAT, and then click the FONT tab.
  7. In the Color box, select WHITE, click on OK button.

    In the Color box, select WHITE, click on OK button.
  8. Click on the Apply button on the Conditional Formatting Rules Manager dialog box.