J jtaiariol Sep 18, 2008 #1 does anybody know how to turn off the green triangle flag that indicates a formula in the cell? thanks.
does anybody know how to turn off the green triangle flag that indicates a formula in the cell? thanks.
M Mike H Sep 18, 2008 #2 Hi, If you select the cell you should see an exclamation mark to the side. Click this and customise errror checking to suit your needs. Mike
Hi, If you select the cell you should see an exclamation mark to the side. Click this and customise errror checking to suit your needs. Mike
G Gord Dibben Sep 18, 2008 #3 The green triangle does not just indicate a formula is in a cell. It indicates an error or anomaly in a cell. Go to Tools>Options>Error Checking and see the option for disabling all error checking or just some. Gord Dibben MS Excel MVP
The green triangle does not just indicate a formula is in a cell. It indicates an error or anomaly in a cell. Go to Tools>Options>Error Checking and see the option for disabling all error checking or just some. Gord Dibben MS Excel MVP
