Formula Drilldown Highlight for Relevant Sections (esp. IF statements)


It would be really helpful if formula drilldown could highlight (maybe bold or with colors) the sections of a formula that actually apply in a specific calculation.


For instance, in formulas with nested IFs, a lot of it will not apply in a particular calculation because the IF condition is not met. However, that is often difficult to tell at a glance. It can be very time consuming to check each condition to determine which one(s) actually apply.


Being able to quickly identify the relevant parts of a formula would make it a lot easier and more efficient to troubleshoot, especially when dealing with very long & complex legacy formulas.

2 votes

New · Last Updated


  • Another vote for this functionality, this would be extremely helpful.

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!