Automatically highlight cells if weekends or holidays

I'm beginner for excel.
I had been referring many excel example to get what I wanted to.
But still couldn't get the formula I need.
Does anyone can help?
I need the Sheet2 to highlight the cells with condition weekends and holidays.
And highlight with different color when leave is taken in Sheet1.
Is it possible to do so? (with the design I've created)
Thanks