MS Excel - Text Hover

https://www.experts-exchange.com/questions/26798376/MS-Excel-Text-Hover-resize-hover-box-to-fit-definition-with-maximum-width-of-50-characters.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