I broke down your question in steps and I solved them one by one. First I tried to get a value TRUE or FALSE based on if the date is in the weekend or not.
=IF(IF(WEEKDAY(DATECELL) = 6; TRUE; IF(WEEKDAY(DATECELL) = 7;TRUE;FALSE));"TRUE";"FALSE")
TRUE == Weekend
FALSE == Weekday
After that I could write the conditions for what to check. In your case if the value is greater then in the quota. We can use this in our final condition for 1 cell. Unfortunatly its very difficult to use conditional formatting for this since I have to use alot of static data I'm not sure if that can be changed but at least I got this for now and it works.
=IF(IF(WEEKDAY(DATECELL) = 6; TRUE; IF(WEEKDAY(DATECELL) = 7;TRUE;FALSE));IF(CURRENTCELL > WEEKENDS;TRUE;FALSE) ; IF(CURRENTCELL > WEEKDAYS;TRUE;FALSE))
Replace words such as:
- Word == With what to replace it
- CURRENTCELL == The cell where you are going to apply the condition
- DATECELL == The cell where the date is located in
- WEEKENDS == Cell where quota is set for weekends
- WEEKDAYS == Cell where quota is set for weekdays
Maybe you could try and figure out if we can get cells relative from the position of the condition. If we can do that we can say from our row C go 2 down to get to the quota of the weekdays.
I found an intreseting question about using something called indirect.
Using twice the same cell with indirect function you could use this to get the static cells and make the condition work like you want them to work.