Blue triangle in top left corner of cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill (St. Jude) - 22 Oct 2007 15:32 GMT

What is the significance of the little blue triangle in the top left corner
of an Excel 2007 cell?

Reply to this Message

Niek Otten - 22 Oct 2007 15:44 GMT

Isn't it green?
Then it might be the error warning symbol. If you select the cell, you'll get an exclamation mark and a drop down telling you what
the "error" is (like referring to currently empty cells)

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| What is the significance of the little blue triangle in the top left corner
| of an Excel 2007 cell?

Reply to this Message

Bill (St. Jude) - 22 Oct 2007 19:06 GMT

Perhaps it is green - it is quite small. There is no error in the cell. A
small line goes across the top left of the corner of the cell and is colour
filled. My spreadsheet has lots of them. Bill

> Isn't it green?
> Then it might be the error warning symbol. If you select the cell, you'll get an exclamation mark and a drop down telling you what
> the "error" is (like referring to currently empty cells)
>
> | What is the significance of the little blue triangle in the top left corner
> | of an Excel 2007 cell?

Reply to this Message

Elkar - 22 Oct 2007 20:25 GMT

This does sound like the Error Checking feature. In Excel 2003 and earlier
the color is green. In 2007, the color is customizable (so it might be blue).

To test, try turning off Error Checking and see if the symbols disappear.

Click on the Office Button
Click on the "Excel Options" button
Choose Formulas on the left
Uncheck "Enable background error checking"
Click OK

HTH,
Elkar

> Perhaps it is green - it is quite small. There is no error in the cell. A
> small line goes across the top left of the corner of the cell and is colour
[quoted text clipped - 6 lines]
> > | What is the significance of the little blue triangle in the top left corner
> > | of an Excel 2007 cell?

Reply to this Message

Bill (St. Jude) - 22 Oct 2007 21:01 GMT

Thank you both for your help. Yes it is the error flag and in my case is
telling me that the cell contains a formula but the cell is not locked to
protect it from inadvertent change.

> This does sound like the Error Checking feature. In Excel 2003 and earlier
> the color is green. In 2007, the color is customizable (so it might be blue).
[quoted text clipped - 20 lines]
> > > | What is the significance of the little blue triangle in the top left corner
> > > | of an Excel 2007 cell?

Reply to this Message