Hyperlink based on cell contents

Hi everyone,

I made a macro that allows me to search in all the sheets the word I am looking for and type it in another sheet.

After that I would like to create a hyperlink in that same code that allows me to go to that sheet and cell if clicking on that link.

I would like also to change the colour of that cell and after returning back to the sheet where I have the data, return to the format that was before.

Could anyone help me on that?

I have attached an image of what I am talking about.

http://i59.tinypic.com/3323wco.jpg

Thank you

In cell F2(and you can drag down):

Please Login or Register  to view this content.