Help with Conditional Formatting when data is not available for continuous days in a week

Hi All,

This time the challenge I am facing is with applying a conditional formatting, the condition is:

If there is no data for continuous four days in a week, e.g., in Week 1 on 8th there is no data, then under Total the week 1 cell should change to RED and If there is data for all the five days in the week, e.g., in Week 2, then under Total the week 2 should change to GREEN.

I have attached the spreadsheet with the data for easy reference and working. Thank you in advance for your time and support.

Thanks again,
ssanjju