Frequently Asked Question

Correct common formula errors while you work
Last Updated 5 years ago

  1. Click File > Options, and then click Formulas.
  2. Under Error Checking, make sure that the Enable background error checking check box is selected.
  3. To change the color of the triangle that marks where an error occurs, in the Indicate errors using this color box, select the color that you want.
  4. Select a cell with a triangle in the top-left corner of a cell.
  5. Next to the cell, click the Error Checking button Button Image that appears, and then click the option you want. The available commands differ for each type of error, and the first entry describes the error. If you click Ignore Error, the error is marked to be ignored for each consecutive check.
  6. Repeat steps 4 and 5

Please Wait!

Please wait... it will take a second!