Vicki has attended:
Excel Advanced course
Cell identification
Is it possible to hyperlink to a cell and have that cell shown in a different colour? I want to hyperlink from a CAD drawing (hyperlink connected) but I would like the cell it links to identified by either a coloured background or a different colour for the cursor around the cell. I have seen a description using VBA but as I don't have the knowledge of VBA I was hoping for a simple answer.
RE: Cell identification
Hi Vicki
Thank you for your question.
Do you only want the cell to highlight when the hyperlink is clicked, and not be coloured any other time? The reason I ask is that from reading your question, it seems that the cell could be coloured in by changing the cell background colour which is quite straightforward but your question seems to indicate that you want to be able to do something more complex than this.
Amanda
RE: Cell identification
Hi amanda
No it is only when the hyperlink is pressed. basically it is to make it obvious where the link has jumped to in a large sheet of figures
RE: Cell identification
Hi Vicki
In this case then this would require VBA coding, as Excel would need to detect when the link is clicked, and only apply colour to the cell if this had happened - I'm afraid there is not a simpler way to do this that I can think of.
Amanda
