We help IT Professionals succeed at work.

MS Excel - Text Hover

557 Views
Last Modified: 2012-05-11
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
Comment
Watch Question

Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
The conditional format bit is relatively simple.

Use a VLOOKUP formula, against the date list, in the conditional formatting dialogue to set the condition.

You might have to do a bit back to front:

=IF(NOT(ISERROR(VLOOKUP(Date,List,1,FALSE))))

Date would be the cell reference of the cell containing the conditional formatting and List would be the list of bank holiday dates.

Not sure about getting the comment.

Cheers
Rob H
Rory ArchibaldGrand Poobah
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

Commented:
Engineer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

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.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.