Highlighting row from hyperlink?

S

spusa

I'm new to conditional formatting in Excel, but I haven't seen this covered
already: I'm hyperlinking a cell from one section of the workbook to data on
another sheet. I would like to highlight the row of data that applies to the
hyperlink from the previous worksheet. Can anyone recommend the appropriate
conditional formatting to make this work? (Note: I'd like to highlight the
row of data ONLY, not run color banding.)
 
G

Gord Dibben

spusa

Don't believe you could do this with CF.

Perhaps the Follow_Hyperlink sheet code would work for you.

Right-click the sheet tab of the sheet with the hyperlink and "View Code".

Enter this code.......

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
ActiveSheet.Cells.Interior.ColorIndex = xlNone
Selection.EntireRow.Cells.Interior.ColorIndex = 6
End Sub

You can have multiple hyperlinks pointing to any sheet and when you go to the
target sheet and row, the row will be yellow.


Gord Dibben Excel MVP
 
S

spusa

Thank you very much, Gord! This worked perfectly, and it was exactly what I
wanted.

spusa
 
Top