Highlight a cell if another is selected

[Olopocram]

Hello,

Is it possible to highlight all cells containing a certain value whenever a specific cell is selected ?
(For example, all cells containing the name Smith turn yellow whenever I select A1 and revert to no highlight when I deselect it.)

Thanks for any reply

[AliGW]

Welcome to the forum.

You’ll need VBA fir this - shall I move your thread?

[Olopocram]

Thanks for your answer. No need to move the thread, I have started another one on the VBA page. Not sure how to delete this one, though...

Thanks again

[FDibbins]

OP has posted this in the VBA forum, so I am closing this thread now