0

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:

screenshot

It doesn't need to change colour or anything, I just want to "see" them more easily.

Improve this question
2
  • any idea how in different way make it looks good ?
    – Bart
    Commented Dec 6, 2017 at 11:48
  • 1
    super! it is not what I was looking for but it will do the job! Many thanks pnuts!
    – Bart
    Commented Dec 6, 2017 at 13:19

1 Answer 1

Reset to default
1

A hack (seemingly adequate according to OP) but options are limited. Put: 

=B3+G3+L3+Q3+V3+AA3

in a cell somewhere and double-click on that to pick out the locations of the components of the formula.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.