Highlight cells, line items, modules Referenced by a Formula


Reviewing and debugging formulas can be difficult and time consuming. This exersize could be made much easier and quicker by highlighting all the line items, cells, modules etc. referenced in a formula. (i.e. similar to when one clicks inside the formula editor within MS Excel, all referenced cells are highlighted with different colour borders and shading)

This will save so much time and concentration brain power when reviewing modules build by others.

I have created a mock-up example of this suggestion in the attached file. In this example line item ATS Total Crusher Feed Utilised (wmt) - Calc for Jun 23 is selected and the edit button of the formula is activated.

10 votes

New · Last Updated


Get Started with Idea Exchange

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