Highlighting row from hyperlink?

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" <spusa@discussions.microsoft.com>
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" <spusa@discussions.microsoft.com>
> 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.)
>
>

So is there a way to make it so the highlighting does not save with the sheet? The highlighting works great, however it keeps the highlighting if you save it. I need it to be more for a visual cue as to the row that was referenced.. I have a multi tab complicated sheet that has a quick reference sheet that links to the tabs/rows

Thank you in advance!