Highlight cells, line items, modules Referenced by a Formula

RijkersB

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.

Highlight formula references suggestion.JPG

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.

Jonathan.Liang

Good Idea! Beneficial for model builders