Highlight cell when cursor is on

**ABSTRAKTUS** · 02-23-2012, 11:56 AM

Hi all,

Just wondering if there is a code that would highlight the cell when you not physicaly select it, but when you put cursor over it?

Thanks in advance guys!

**ABSTRAKTUS** · 02-23-2012, 12:11 PM

Let me be more specific then, if it helps. I need hyperlink to change colour when you put cursor over it. Would this be possible?

**ABSTRAKTUS** · 02-23-2012, 12:32 PM

Alright. That means no. Just wanted to do something like "web style" spreadsheet...

**OnErrorGoto0** · 02-23-2012, 12:47 PM

Well, you can bodge it with something like the attached, but you would need quite a bit more work to make it nice.

**ABSTRAKTUS** · 02-23-2012, 12:52 PM

Absolutely impressed! Just like what I'm looking for. However, question: how do I change the colour?

**OnErrorGoto0** · 02-23-2012, 12:53 PM

It's set in the conditional formatting for the range. Just edit the format as required.

**ABSTRAKTUS** · 02-23-2012, 01:14 PM

I can't get it working on the actual workbook. Copied the code, conditional formated, no success.

**OnErrorGoto0** · 02-23-2012, 01:17 PM

Did you alter your hyperlinks to use the code function, and add the CurrentRow name?

**ABSTRAKTUS** · 02-23-2012, 01:20 PM

Can you please guide me on this? I don't really know what do you mean and how to do it...

**ABSTRAKTUS** · 02-24-2012, 09:27 AM

I've done everything, but no success. After hours of Googling I found that something is not compatible with my XL version I run, because of _xlfn (don't know what is it), Changed IFERROR to IF(ISERROR and still nothing happens. Where am I wrong?