Show selected cell visually with colour cross reference

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Show selected cell visually with colour cross reference

Post by Rudi »

Hi,

I have never seen this before, but I was asked recently if there is a way to have Excel hi-lite the selected cell by shading the cross reference of the column and row with a colour. Excel already hi-lites the column and row selector in orange based on the cell selected, but can that be extended into the column and row so that the cell is easily identifiable?

Never seen it before, but maybe someone knows of an add-in that can do this?? :smile:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

steveh
SilverLounger
Posts: 1952
Joined: 26 Jan 2010, 12:46
Location: Nr. Heathrow Airport

Re: Show selected cell visually with colour cross reference

Post by steveh »

Hi Rudi

Welcome Home

I have somewhere a workbook that demonstrates a kind of cross hair set up that shows where you are on a sheet, until I find that could this be useful? http://www.vbaexpress.com/kb/getarticle.php?kb_id=145" onclick="window.open(this.href);return false;

Editted to add:

Found it, it is Chip Pearsons web site http://www.cpearson.com/Excel/RowLiner.htm" onclick="window.open(this.href);return false;
Steve
http://www.freightpro-uk.com" onclick="window.open(this.href);return false;
“Tell me and I forget, teach me and I may remember, involve me and I learn.”
― Benjamin Franklin

User avatar
HansV
Administrator
Posts: 79030
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Show selected cell visually with colour cross reference

Post by HansV »

Before installing and using the RowLiner add-in, please read the Known Issues section at the bottom of the article.
Best wishes,
Hans

User avatar
Jan Karel Pieterse
Microsoft MVP
Posts: 656
Joined: 24 Jan 2010, 17:51
Status: Microsoft MVP
Location: Weert, The Netherlands

Re: Show selected cell visually with colour cross reference

Post by Jan Karel Pieterse »

Have a look if this one fits your needs...
You do not have the required permissions to view the files attached to this post.
Regards,

Jan Karel Pieterse
Excel MVP jkp-ads.com

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Show selected cell visually with colour cross reference

Post by Rudi »

steveh wrote:Hi Rudi

Welcome Home
Many TX Steve.... It's great be be "home" and amongst family again! :grin:

Thanks for the links. I knew there would be something out there to meet the need! Cheers my friend. :cheers:

Hans; :thankyou: for the warning! (Rather safe than sorry)

Jan Karel; This is a very interesting technique...using those arrows to indicate the current cell position. Thank you for that input. Very smart!!! :clapping:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.