Hello,

New to the forums here.

I have tried (in vain) to locate a resource to help me do what I want for an Excel spreadsheet.

I have a worksheet that has multiple hyperlinks in it. These hyperlinks connect to various different sheets and cells in the spreadsheet. This part I can do with no problem.

Here is my conundrum: I would like for each hyperlink (when it is clicked) to link to the correct cell/data and then have that appropriate cell/data highlighted. After the user leaves this spreadsheet, then I would like the highlighting to disappear. Please note that the sheets to which the hyperlinks take you, do have colors already on them (i.e. in headers, table rows, etc.)...so this un-highlight function cannot just make the entire worksheet blank (i.e. without color).

I hope this is clear enough, and I hope somebody can help me ASAP.

Many thanks,
Jon