Copy and past from different sheets based on different criteria then sum certain columns

If I'm understanding correctly, then select A2:E23, select conditional formatting --> new rule --> use a formula, then use the following formula:

=VLOOKUP($A2,Sheet3!$A$2:$D$7,4,FALSE)>SUMIF($A$1:$A1,$A2,$D$1:$D1)+SUMIF($A2:$A$23,$A2,$C2:$C$23)

I'm not sure whether you just want to highlight just the zero-quantity rows that qualify or all rows with the item# that qualifies. The formula above will do the latter. Hopefully that's what you're looking for? Experiment with the attachment to see if it works as desired:


EDIT: You can delete column F in the attachment, it's just a test column indicating which rows (those marked TRUE) will trigger the formatting.