Runs the Highlight Inconsistent Formulas command from the Assist Pro toolbar.
Assist Pro + → Templates and Present → Other → More → Cleaning Consistency → Highlight Inconsistent Formulas
Part of Assist Pro+. Eligible tools can also be selected through Assist Pro’s 30-tool Vault allowance. Check the Vault for availability.
Open the tool and follow its prompts. Use a copy of your workbook when trying an action for the first time, then check the result.
Browse all toolsPrepare and select the relevant range, worksheet or table in the intended workbook. On Assist Pro + › Templates and Present › Other › More › Cleaning Consistency, choose Highlight Inconsistent Formulas to runs the Highlight Inconsistent Formulas command from the Assist Pro toolbar. Inspect the output and save the workbook after confirming it looks right.
Useful when polishing a worksheet for review or reporting and you need to run the Highlight Inconsistent Formulas command from the Assist Pro toolbar.
Speeds preparing clean, readable report layouts when you need to run the Highlight Inconsistent Formulas command from the Assist Pro toolbar.
Improves workpaper presentation and reviewer readability by helping run the Highlight Inconsistent Formulas command from the Assist Pro toolbar.