troubleshooting Question

MS Excel - Text Hover

Avatar of Andross9
Andross9 asked on
Microsoft ApplicationsMicrosoft Excel
3 Comments1 Solution561 ViewsLast Modified:
https://www.experts-exchange.com/Microsoft/Applications/Q_26798376.html

Question:

I have a worksheet were column A contains a series of dates.

I also have a public holiday data set, where each of the public holiday dates have a dependant definition
e.g.:
C3 = Friday, 25 December 2009      
D3 = Christmas Day

If a date within the worksheet is the same as a public holiday date in the data set, I want to be able to hover over the date and have a comment box display with the public holiday definition as per the data set. I also want the date in column A to conditionally format (change colour) on the basis it is a public holiday date.

I would also like the comment box to resize itself to ensure a maximum character width of 50 characters is displayed.
 
I have attached a copy of a workbook with an example.

Any help would be greatly appreciated.

Andross
 Public-Holidays-Example.xlsm
ASKER CERTIFIED SOLUTION
Saqib Husain
Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros