cell identification

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell identification

Cell identification

resolvedResolved · 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

RE: Cell identification

Thanks Amanda,

I guess we will have to live without it for the present.


 

Excel tip:

How to Remove Duplication's from a selection of data in an Excel 2010 Worksheet

It 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:-

1) Select the data that might contain duplication's
2) Click the ''Data'' tab
3) Go to ''Data Tools'' and click ''Remove Duplicates''
4) A box will appear. Tick the boxes of the columns that you want to use to check for duplicates. Finally, click ''OK.''

View all Excel hints and tips


Server loaded in 0.11 secs.