Excel: Green Error Mask

Description: This is the familiar green mark appearing in the left top corner of the cell. It indicates that, the data present in the cell is having some discrepancy or error. It is up to the user to correct the errors.

Number Stored As Text
One such indication is number is stored as Text. If a number stored in text format, this data will not be considered for any formulas referring the cell; in turn gives wrong data or result.

For avoiding this error, click on the cell and select the icon appearing on the left side of the cell
For Selecting all such errors in the sheet and act on it, press Ctrl+A two times. Click on one cell contains the error mask, press ctrl+A twice for selecting the entire sheet. Then the icon will appear on the top left corner of the sheet.


Inconsistent Formula
This error mark represent the cell is having a formula which is different from the adjacent cells. In the below screen shot, we used the formula as Amount*3.2% in all cells except the one with green error mask, where we used the formula Amount*3.3%.

Formula Omits Adjacent Cells
This indicates that the formula is omitted some data adjacent to it. In the below example, we calculated the Total revenue as a sum of revenues from Jan to April. After that, we added the revenue of May.