Selective Highlighting Of Leaves Holiday In Calendar Through Conditional Format

[msiyab]

Hello Guys,

I would like to know how to perform selective highlighting in excel.
Basically, I have a calendar in excel and besides that are names of employees of my dept. So i need some formula or VBA or anything that highlights the annual leave days on the calendar when I click on a employees name.

Sheet 1 is the 2013 calender and besides it are the names of the employee (when clicked needs to highlight their respective leave days), Sheet 2 contains the names of employees and their leave dates. Please note, i will change the names in Sheet 2 according to the departments.

Please find the attached workbook...

Thanks...