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.)

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




On Tue, 20 Sep 2005 12:41:05 -0700, "spusa"
wrote:

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.)

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

spusa

"Gord Dibben" wrote:

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




On Tue, 20 Sep 2005 12:41:05 -0700, "spusa"
wrote:

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.)