Did you know that those triangles in my cells in Microsoft Excel are useful indicators?
In Microsoft Office Excel, there are seven options buttons and three colored triangles that can appear in or next to a cell. These buttons and triangles provide useful commands and information about the contents of the cell, and they appear at the moment you need them. This TEI tip describes what each of these triangles mean and how you can work with them.
Colored triangles that you might see in your worksheet
The three colored triangles that can appear in a cell are green (error), red (comment), and purple (smart tag (smart tags: Data recognized and labeled as a particular type. For example, a person’s name or the name of a recent Microsoft Outlook e-mail message recipient is a type of data that can be recognized and labeled with a smart tag.)).
A green triangle in the upper-left corner of a cell indicates an error in the formula in the cell. If you select the cell, the Trace Error button appears. Click the arrow next to the button for a list of options. TIP The color of the error checking triangle indicator can be changed. Use the following procedure to change the color:
1. Click the Microsoft Office Button , click Excel Options, and then click the Formulas category.
2. Under Error Checking, select the Enable background error checking check box.
3. Click the Indicate errors using this color button, and then select a new color
A purple triangle in the lower-right corner of a cell indicates that a smart tag is in the cell. If you rest the mouse pointer over the triangle, the Smart Tag Actions button appears. Click the arrow next to the button for a list of smart tag options.