; formulas that areinconsistentor different from formulas in surrounding cells; and numbers formatted as textdata.
When you select a cell with a green triangle, theError Optionsbutton appears next to it.
TheError Optionsbutton is a yellow diamond with a gray square background.
It offers options for correcting the perceived error.
Go toFileand selectOptionsto open theExcel Optionsdialog box.
In theError Checkingsection, clear theEnable background error checkingcheckbox.
SelectOKto accept the change and close theExcel Optionsdialog box.
You’ve now turned off the green triangle indicators.
Changing the Error Checking Rules
Make changes to error-checking rules in the Excel Options dialog box.
SelectOKto apply the changes.
You’ve set your new error-checking rules.
SelectOKto accept the change and close theExcel Optionsdialog box.
You’ve changed the color of the error-indicating triangles.
To read the comment, hover over the cell containing the red triangle.
A text box containing the comment appears next to the cell.
To change the comment options:
Select theAdvancedtab.
SelectOKto accept the changes and close theExcel Optionsdialog box.
