Help Needed -- Forecasting Model Formulas (IF,AND)

Attached is a long range forecasting model, in which installer quantity is tracked per job and team on a daily basis. The formula I am struggling with are the items below.

Item #1
$J11 Value automatically inputting into the Start and End Dates on the calendar schedule. Below is the formula I am trying to manipulate.
=IF(AND($G11<=L$10,$H11>=L$10),$J11)

Item #2 (Much less important)
The cells in the calendar schedule matching the color scheme of each individual Sales Team in Column F.

Thanks!

View attachment Forecasting Model.xlsx

Im not sure if I understand, but I think your saying that if the date in column L10 falls between (or is = to) the dates in Columns G11 and H11 then you want to return the value from Column J11 (in L11)
If that is correct, then if you copy your Item #1 formula into L11 and then across and down into all the cells that are working days, this will do it.
Then, if you copy from F11, then select E11:FH11 and Paste Special/Formats [Enter] this will make the background yellow all the way across.
Repeat above for rows 12-15.