Check Mark shown

[Angus McBagpipe]

I have created a formula dealing with TIME
=IF(B7="","",TEXT(D7-B7,"h:mm")-C7)
The formula works fine but the cell shows an unexpected "green" check mark.
It not part of the returned value, it's just there.

Any ideas of how to get it gone?

 

[Fluff]

Do you mean a little green triangle in the top left of the cell?

 

[Angus McBagpipe]

Do you mean a little green triangle in the top left of the cell?

We might be talking about the same thing.
On my system ... Excel 365 it is a green "bit map" check mark on the left side.

 

[Fluff]

In that case I don't think we are talking about the same thing.
Have you looked to see if there is any conditional formatting on that cell?

I was talking about the error warning triangle that appears in the top left corner of a cell on some occasions.

 

[Gerald Higgins]

TOP left side ?
If yes, it's a warning from Excel that it thinks there is some anomaly with your formula.
If you click on the cell, you might get another symbol appearing, with an exclamation mark in it, and if you hover over that, it will tell you why it thinks there is an anomaly.
For example
"The formula in this cell differs from the formulas in this area of the spreadsheet"
and there are several other possible messages.

You can just ignore the message if you like, and if you click on the symbol with the exclamation mark, you should get a menu appearing which includes options to change the ways that these types of anomalies are handled.

 

[Angus McBagpipe]

Do you mean a little green triangle in the top left of the cell?

Nope ..... It is very much a green check mark. Left side and full height of the cell.
I'm using Office 365 , Excel

 

[Fluff]

Have you checked to see if there is any conditional formatting for that cell?

 

[Gerald Higgins]

Can you post a screenshot of it ?

 

[Angus McBagpipe]

How do I post a screen shot?

 

[Fluff]

Any chance you could answer my question?