Working with dates & conditional formatting

[ALAMZEB]

hi Guys

thanks in advance

The due date is from customer and weekly shipping date from us supplier)
can we create formula that works with dates and conditional formatting

as per attached

data from column A to V
shipping dates from supplier from column BF to BL

can formula find out if due date is less than shipping date than higlight qty according to delievery date, attached will make more sense

 

[Hui]

BF5: =SUMIFS($Z5:$BE5,$Z$4:$BE$4,">="&BF$4,$Z$4:$BE$4,"<"&BG$4)
Copy across and down

I'm not quite sure that the >= and < logic is right but you can test

 

[ALAMZEB]

hi nebu

its works but but can i send this formua in conditiona formatting, just turning color according to deleivery week color?