In O3:O100 I have a series of names. On clicking on a name , I'd like to highlight each occurrence of it in F3:F300. The cells in both columns have simple text in each.
I guess it could be done by simply selecting the relevant cell or by double-clicking.
The highlight would make the font of the selection red in both O3:O100 and F3:F300. Clicking or deselecting the selection in O could toggle both columns back to dark blue.
Can someone advise some code to satisfy this?
Grateful for any help.
![]()
Bookmarks