Selective Highlighting Of Leaves Holiday In Calendar Through Conditional Format

[msiyab]

Thanks for the help!! You guys are just great.

However, i aint that advanced to understand what you wrote with the coding above. But the file does its job nonetheless.

I would like to know though, how did you make the drop down list next to the calendar?