Hi Narayan,
Thanks for rapid response,
I have around 20 cells on sheet-1 which are hyper linked to respective description cells on sheet-2.
It is OK, if it will highlight in one color only. At least it will be visible to to user.
Thanks again Narayan.
Thanks Narayan and SirJB7 for your reply.
I will restate my query:
I have three sheets in my workbook.
Sheet-1 has some column say Head Office(A4), Panel #(A5), Region(A6) etc.
Sheet-2 has a Screen shot on which, I have tagged all these field name like Head Office, Panel #, Region etc...
I want to highlight the hyper linked tags whenever it get clicked. I will make my quesry simple by this e.g.
If I am clicking A1 from sheet-1 and it is linked to C4 at sheet-2 than C4 should change its color.
Also, Is it possible if a cropped bar I've pasted on picture. I want it in different...