Highlight formula cell and its precedents using a selected color.
Assist Pro + → Audit and Analysis → Data Checker → Highlight Precedents
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 toolsOpen the relevant transaction listing or financial-data range and check that dates, amounts and headers are correctly typed. On Assist Pro + › Audit and Analysis › Data Checker, choose Highlight Precedents to highlight formula cell and its precedents using a selected color. Check the result and confirm that it applies to your intended workbook.
Tracing which cells feed a formula during review.
Speeds quality checks of operational lists and reports when you need to highlight formula cell and its precedents using a selected color.
Reduces manual general-ledger scanning and exception testing when you need to highlight formula cell and its precedents using a selected color.