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

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.