conditional formatting in calendar

[albert28]

Hi guys,

i need help with the attached spreadsheet. It's a monthly calendar that i have made but i have problems in conditional formatting in regarding of highlighting the holidays of the month. i.e on the attached spreadsheet on column AT-AU is the dates of all declared holiday, when i click refresh button, it will highlight the date based on the holidays lookup all employee will highlight downwards.

hope anyone here can help me.


thanks,
Albert