Find Inconsistent Formulas
The Formulas menu offers two options - Find Inconsistent Formulas in Columns and Find Inconsistent Formulas in Rows. They both work on the selected range, and with the Columns option comparing formulas vertically and the Rows option comparing them horizontally.
Key Points
- When an inconsistent formula is identified, the cell is marked with the built-in Excel "Bad" cell style.
- If applied to a row or column within an Excel Table, be aware that several of the red table styles may make the "Bad" cell style less obvious.
- After making corrections, you can use Restore Formats to revert the formatting to its original state.