Excel: Rollover Effect for calendar based on event date

Question

I have my custom made calendar where I emphasize special events using formulas in conditional formating:

=NOT(ISERROR(MATCH(G14;EVENTS;0)))

where EVENTS is a range of dates with some event occurance.

EVENTS             Description
08.05.2014          Anniversary
10.05.2014          Meeting

Now, I would like to create a mouse rollover efect within the calendar area, which would show the description of the event (something like a dynamic comment) when moving the mouse over emphasized date in calendar.

I was thinking of using hyperlink and help of How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell , but I am not sure how to match the dates with description.

Thanks a lot

score 0 · Answer 1 · answered Feb 08 '14 at 23:02

Take a look at these tutorials:

I am the author of the blog cited above, so please let me know if you have trouble implementing the tutorials above.

Excel: Rollover Effect for calendar based on event date

1 Answers1