Conditional Cell Range Highlighting

[ADHEND23]

Hello,

I am trying to create a code that will highlight certain cells once a hyperlink has been clicked. I have multiple hyperlinks on the same sheet that, once clicked, link to certain cells on separate sheets. I would like to know if I can have a user click a hyperlink and have them be taken to the new sheet and have those cells become highlighted.

I would also like those cells to become un-highlighted once the user either switches sheets or clicks a new hyperlink.

I am not too familiar with VBA but I believe that would be the easiest route. If anyone can lead me in the right direction I would greatly appreciate it.

Thank you,
ADHEND23

 

[onlyadrafter]

Hello,

If you create a screentip for each of your hyperlinks, you could use the following code, which needs to go into the relevant sheet code window, not a standard module.

 Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    Sheets("Sheet2").Cells.Interior.ColorIndex = xlNone
    Select Case Target.ScreenTip
        Case "a"
            Sheets("Sheet2").Range("A1").Interior.Color = vbRed
        Case "b"
            Sheets("Sheet2").Range("A3, A5").Interior.Color = vbGreen
    End Select
End Sub

Is this feasible?