• 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

    Hui...

  • 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

C

Cropston

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.
 
Attached is an example of what i would like to do.

Thanks in advance.
 

Attachments

  • LINK eg.xlsx
    15.5 KB · Views: 5
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 ?

Narayan
 
You must log in or register to reply here.
Back
Top