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
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.
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.