Multiple Conditional formating required

Good day

Please see the attached
I managed the formating already allocated to the sheet named full
I also need to allocated different a colour for the "Full" sheets based on the dates in the "Data" sheet this is the current dates as well as dates still to follow. (if possible use orange)
I also need to allocated different a colour for the "Full" sheets based on the dates in the "Holidays" sheet this is the current dates as well as dates still to follow. (if possible use blue)
It is 01:25am so i might not be thinking clear, everytime i add a new one i overwrite the previous

Off to bed but would sincerly appreciate any help

Hi

Thank you so much, this is great, really apreciate this, it places the formating in both months because of the way the calander was created
This is fine

Well deserved, out of all the views you were the only one to resolve the question, so only a pleasure