Trace
Trace precedents and dependents in a more intuitive way.
Input Parameters/Data
Cell: Name and Reference of the cell to trace.
Format Fill: Filter of precedents / dependents to format fill.
Cells are format filled as follows:
- Direct PrecedentsDirect precedents of the selected cell.
- Indirect PrecedentsIndirect precedents of the selected cell.
- Direct DependentsDirect dependents of the selected cell.
- Indirect DependentsIndirect dependents of the selected cell.
Notes
Most runs are completed within 3s.
The number of impacted cells and sheets are provided.
Clears any regular or conditional format fill on impacted sheets.
Output
Summary: Summary of all trace results.
Format Fills: Format fill of sheets with precedents / dependents based on the format fill filter.
View demo here
Learn the basics in 5 minutes with our Quick start guide. To make the most of Fontics, check out our Tips & tricks.