inconsistent formula green flags

Background Error Checking is an Application setting - if you don't want it active at all then disable via options.

If you're saying you want to keep the Error Checking active but find a keyboard shortcut to replicate clicking on the exclamation mark and choosing Ignore Error - I confess I don't know one.

Handling Error Checking can be a pain in truth... VBA wise I can't find anyway other than iterating through the various types - ie assigning the below to a keyboard shortcut

Please Login or Register  to view this content.

Hopefully there's a better way....

Go to Tools->Options, select the "Error Checking" tab, and unclick the
"Inconsistent formula in region" box, or to turn off all error checking,
unclick the "Enable background error checking" box.