Darn I think i missed an important bit of information.

I have the totals rolling up in one spot.

so that formula would end up referencing the same cells i believe.
I was thinking that I would end up having to use an IF/AND combo, but can't get the logic down.

So how it works is the quantities roll up in cells A 6, 7 and 8
and the grids turn green as the numbers hit the minimums so long as all three categories have hit the minimum number.
There are actually two grids, as there are two levels of applicable discounts, one where you don't have to hit every category to qualify, and one where you do.

I really hope that makes sense.

Would it be easier to reference two separate cell ranges for this?