The Green Triangle
The green triangle appears in a cell when the cell’s contents violate one of Excel’s error-checking rules. These rules are turned on by default and monitor for common mistakes such as cells containing formulas that result in an error, including #VALUE! or #DIV/0!; formulas that are inconsistent or different from formulas in surrounding cells; and numbers formatted as text data. When you select a cell with a green triangle, the Error Options button appears next to it. The Error Options button is a yellow diamond with a gray square background. It offers options for correcting the perceived error.
Turn off the Green Triangle
Error checking is turned on by default in Excel, so the green triangles appear in cells that contain a rule violation. If you don’t want to see these indicators, change this default setting and turn off error checking in the Excel Options dialog box.
Changing the Error Checking Rules
Make changes to error-checking rules in the Excel Options dialog box.
Change the Color of an Error-Indicating Triangle
If you prefer, change the green default color of the error-indicating triangle in the Excel Options dialog box. To change the green triangle to a different color:
Red Triangle in Excel Cell
A red triangle in the top right corner of a cell indicates that someone added a comment to the cell. To read the comment, hover over the cell containing the red triangle. A text box containing the comment appears next to the cell. There are some comment options. Opt not to display comments or indicators, even when hovering over a cell containing a comment. Or, opt always to display comments and indicators for all cells containing comments. To change the comment options:
