• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating a Link to Highlight Multiple Individual Cells NOT over a Range


New Member
Hi there,

I would like to create a system, i think through hyperlinking, where i can click on the title link in a table and on the same open sheet it highlights the values matched to that title in multiple cells. e.g. i click the link and it highlights desired cells A1, H5 and L10.

Please, could you help me resolve this issue. I feel like it is quite a simple issue that doesn't require coding but i am not sure.

Thanks in advance.


Excel Ninja
Hi ,

I am not clear on why you would need a macro for this.

Can you add any more detail on what would be done after these three cells are selected ?

Also please indicate whether the cells are in column B or column C ?