Debbie has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Excel 2003
Is there a way I can turn off the inconsistent formula green triangle thing? It is useful sometimes but often it's just warning me about something and after the 10th time it appears I'd like it to go away!
RE: Excel 2003
Hello Debbie
Thank you for your question and welcome to the forum.
If you go into Tools - Options, and select the Error Checking tab, under Rules, uncheck all the rules relating to formulas:
Inconsistent formula in region
Formula omits cells in adjacent region
Unlocked cells containing formulae
Formulas referring to empty cells
This should stop the majority of green triangles appearing.
Kind regards
Amanda