Green Triangles in Cells

  • Thread starter Thread starter Dwight
  • Start date Start date
D

Dwight

Does anyone know what the green triangles in top left
corner of a cell are for?

I know red triangles are comments.

Thanks in advance!

Dwight
 
They are from Excel XPs Error Checking function. You can
set your options for this under Tools;Options; Error
Checking tab.
 
Hi Dwight,
Does anyone know what the green triangles in top left
corner of a cell are for?
Click to expand...

They indicate warning messages. Often related to the fact that the
formula in such a cell differs from its neighbours.
Once you select such a cell, you'll see a smart tag appear (tiny
rectangle with an exclamation mark in it). Click it to see what Excel
is complaining about and maybe take corrective measures.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Non matching text data of the same values 3
What is small green triangle in upper left corner of cell? 6
Subtotals 5
what is the geen triangle in a cells with number? 4
How do I eliminate the green triangle throughout my spreadsheet? 2
How do I ignore the "Number stored as text" error message permane. 3
Stop error checking a cell that has been formatted to text 3
Green corner in cell?????? 2

Back
Top