Highlight a cell when using hyperlink

Question

Highlight a cell when using hyperlink

Anonymous

Hi

i have hyperlinked to a cell on a different worksheet in Excel. i am wondering if i can get the cell to have a different background color or bold text or such when it becomes the active cell.

So if hyperlink goes to Worksheet 2 cell A52, I would like A52 to have the highlight so i can distinguish it from the cells around it.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

Hi,

If what you expect is to automatically highlight the destination cell (Sheet2!A52 in your case) when it's reached (selected) after clicking on an hyperlink; then yes that's doable:

This requires a short macro to force the recalculation of the selected cell. Consequently this will have a cost as the macro will run each time the selection changes...

CONDITIONAL FORMATTING

Select the target cell (Sheet2!A52 in your case)
Home / Conditional Formatting / New Rule...
Choose Use a formula to determine which cells to format
Enter the formula: =ADDRESS(ROW(),COLUMN())=CELL("address")
Choose your formatting and validate

MACRO

[Alt]+F11 to open the VBA window
Double-click on Sheet2 under VBAProject...
Copy the following code and paste it into the right part of the VBA window

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Target.Calculate

End Sub

Finally close the VBA window and test.

Hope this helps

Cheers

Lz.

Share via

Highlight a cell when using hyperlink

0 additional answers