98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Cell identification
Cell identification
Resolved · Urgent Priority · Version 2003
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:How to Remove Duplication's from a selection of data in an Excel 2010 WorksheetIt would take far too much time to scan through rows and rows of data to find and remove duplicate data. So, here's how to do this using a much more efficient method:- |