Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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.) |
#2
|
|||
|
|||
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.) |
#3
|
|||
|
|||
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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Run a Hyperlink from another cell | Excel Discussion (Misc queries) | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
Importing Access File with Hyperlink | Excel Discussion (Misc queries) | |||
Removing hyperlink | Excel Discussion (Misc queries) |