A red triangle in the upper-right corner of a cell shows the presence of a note. The text of the message may be viewed by hovering the mouse pointer on the triangle. Clicking on the triangle displays the notes in the cell.
Comment indications are the red triangles in the top-right corners of cells. When you see one of these, it means that someone used Review or New Comment to add some explanatory language to a cell. When you hover your mouse over a red signal, Excel displays the comment, as seen below.
Excel Cell with a Red Triangle A red triangle in the upper right corner of a cell shows that it has received a remark. A red triangle in Excel 2019 denotes a note. A purple arrow in the corner indicates a threaded comment, which is used to respond to an original comment and add additional comments.
The presence of user comments in the worksheet cell is indicated by red triangles. The green triangle appears in the upper left corner of a cell, whereas the red triangle appears in the upper right corner. Here's an explanation of how these indicators work and how to adjust their default settings.
In a worksheet, the cell cursor is a black border that surrounds the active cell (also known as the current cell). The cell address—the current cell location—is displayed in the box at the left end of the Formula bar. To change which cell is active, click in the sheet where you want the new active cell to be.
When you initially insert text into a cell, its angle is 0 degrees and it reads from left to right. As you begin to type more characters, the next character will appear at the angle where it makes the most sense for the reader's eye to go instead.
The typographer's term for this is "horizontal writing". When you write words in a letter from left to right, the next one appears at an angle that is convenient for reading. If you know anything about handwriting, you can see that this is also how people sign their names. They don't slant their letters like computers do; instead, they write in a horizontal fashion, with each letter appearing at its own angle.
In computer-generated text, these angles are called "glyphs". To create more variety in your text, some software allows you to create custom glyphs. For example, if you were to create a logo with Photoshop, there would be no reason why it couldn't be used in text documents as well. The only difference between the two files would be their font list: one file might have Arial as its default font while the other could use Helvetica or whatever else you chose as its default look.
A purple triangle in the lower-right corner of a cell shows the presence of a smart tag. When you hover your cursor over the triangle, the Smart Tag Actions button appears. Click this button to open a list of commands that can be applied to the cell.
There are seven choices buttons and three colored triangles that can display in or near to a cell in Microsoft Office Excel. These buttons and triangles give important commands and information about the cell's contents, and they only display when you need them. They can help you work with numbers, texts, formulas, and other cells much faster than trying to find them by touch alone.
The triangle in the upper-left corner is the calculation button. Click it to automatically calculate the value of any enclosed formula or function. Scroll down to see the other options buttons.
The triangle below the calculation button indicates whether or not the cell contains a formula. If it does, then clicking this triangle will show you the Formula Bar, where you can enter new formulas. Otherwise, no triangle appears, and you cannot use this method to enter formulas.
The color coding system used by Excel to indicate different types of data is as follows:
Red text means danger - an error has been entered into the cell. Avoid entering red text into cells that will be viewed by others.
Orange text is warning - this cell might contain something that shouldn't be entered correctly. It's better to have an orange cell than a red one.
Green text is normal - these cells usually contain data that should be entered into your worksheet.