How to find all Inconsistent Formulas (green indicators)?

[theanchorman]

Hello, I was looking to see if there was an easy way to find all inconsistent formulas in the workbook or list them out by cell references? Is there a vba code that can be written? Currently I see the small green triangle indicator in a cell if there is in inconsistent formula in the top right of a cell, however my file is very large with muliple tabs so i was trying to find an easier way I can find them or have them listed out.

 

[MountainFog]

Go to the formula tab and then hit error checking. If you click options you can edit error checking rules, and then it will work like the Find feature.

 

[Alex Blakenburg]

If you are working for a larger organization and are on the Enterprise edition of Excel you will most likely have access to the Microsoft provided add-in called Inquire.
You just need to turn it on File>Option>Add-Ins>Manage COM Add-ins>tick Inquire

It was built as an auditing tool and acquired by MS.
This article gives you a lot of information on what it can do specifically covering what you are asking for.

Investigate Excel sheets using Inquire · Dutch Data Dude

www.dutchdatadude.com