Hyperlinks and conditional formatting

**Lev1948** · 05-04-2016, 10:59 AM

Hi

My problem is that I want a hyperlinked cell to change colour and font when it is accessed. i'e. when the hyperlink is clicked, the destination cell in the same workbook changes colour so that it stands out on the sheet.

I have around 140 hyperlinks accessing various cells in 9 worksheets.

If you can help I would be most grateful.

Regards
lev

**tony h** · 05-04-2016, 12:03 PM

Welcome to the forum. There are various options whizzing around depending on why you are trying to do this.
Could you give a bit more information about how the spreadsheets are being used.

**FDibbins** · 05-04-2016, 12:57 PM

Originally Posted by Lev1948

Hi

My problem is that I want a hyperlinked cell to change colour and font when it is accessed. i'e. when the hyperlink is clicked, the destination cell in the same workbook changes color so that it stands out on the sheet.

lev

A H/L changes shades when you click on it anyway (until you close and re-open the file), but to make that change stay there - or to make the destination cell change color, I think will require VBA

**FDibbins** · 05-04-2016, 12:57 PM

deleted my duplicate post

**Lev1948** · 05-04-2016, 01:43 PM

That's what I thought - my knowledge of VBA is sketchy to say the least but I will give it a go

Thanks

**tony h** · 05-04-2016, 02:02 PM

Originally Posted by Lev1948

That's what I thought - my knowledge of VBA is sketchy to say the least but I will give it a go

Thanks

As I said before : if you describe what you want to do I can help.

**Lev1948** · 05-04-2016, 06:33 PM

My spreadsheet is a record of a swimming gala with all the results in age groups on 7 separate sheets. Each age group sheet has around 10 results for that age group with defined name headings for each event.

The menu page is where I've collated all my hyperlinks that link to the respective result. For instance, click the 9 year girls 100m Butterfly and it sends you to the result heading (the defined name).

What I want is for the heading to be highlighted in a colour so that it is easily spotted on the sheet.

I hope I've explained in sufficiently for you.

Regards
Lev

**tony h** · 05-05-2016, 06:31 AM

That's useful. If you could attach a sample (please remove any real names or other identifiable information) use the Go Advanced option on the reply.

I presume you created the hyperlinks by hand. How often would this be re-done (if at all)?

**Lev1948** · 05-05-2016, 06:53 AM

Hi

I won't need to use any more hyperlinks (they were all done manually). I've removed columns B and K - they had the names of the swimmers.

When you click a link on the Menu sheet it goes to the relevant page and set of results. These destination cells are the ones I would like to highlight when they are accessed by the hyperlinks.

Spreadsheet attached.

Regards
Lev