What does the green tag in the top left of a cell mean?
 

I am preparing a table with values and percentages but in some areas (where
I'm doing a % calculation) a small green tag appears in the top left of the
cell with an exclamation mark. It suggests an error but the calculation is
right. What does the green tag mean and how do I get rid of it?

xl2002 added some checks--things like numbers stored as text or inconsistent
formulas.

You can see all those things that excel will check under:
tools|Options|Error checking

If you click on that little exclamation point, you'll see what excel thinks may
be wrong. You can tell excel to to ignore this (or you can even tell excel to
stop bothering you completely).

dasher wrote:

I am preparing a table with values and percentages but in some areas (where
I'm doing a % calculation) a small green tag appears in the top left of the
cell with an exclamation mark. It suggests an error but the calculation is
right. What does the green tag mean and how do I get rid of it?

--

Dave Peterson