In the attached file range A11:AE25 I would like some conditional formatting which would check the following.
If the dates before today have not been filled and are not weekends then color those dates (row 11 to 25) red.
If any of the dates filled does not sum up to 8 then color the entire date range (row 11 to 25) green.
I did make an attempt which was working at the end of November but is now not working for December. Timesheet.xlsx