Shading weekends/holidays

[kurtis.fafard]

I would like to have all holidays and weekends automatically shade to light yellow fill with dark yellow font. All I can seem to manage to do is get the current date to turn green and get the =WEEKDAY function to work. Any help would be greatly appreciated. I have included the spreadsheet below.

Thanks again,

Kurtis Fafard