I would like to know if it is possible to just click one cell and then different cells be automatically highlighted. For example, when I click B3 cell I would like to highlight cells: G3, L3, Q3, V3, AA3:
It doesn't need to change colour or anything, I just want to "see" them more easily.
Best Answer
A hack (seemingly adequate according to OP) but options are limited. Put:
in a cell somewhere and double-click on that to pick out the locations of the components of the formula.