If a range contains value greater than zero then are those cells on corresponding rows also containing values greater/equal to zero

[moccasinus]

Hi,

I'm struggling with ranges, check if you could help me out:
If a range contains value greater than zero then are those cells on corresponding rows also containing values greater/equal to zero.
What I want to achieve here is to check whether a ProductX that has demand:

Also has all the raw materials in stock in order to start manufacturing it:

Best outcome would be TRUE, so I could conditional format it. There are lots of raw materials for one product.
I guess it should be done with a combination of sumproduct and transpose, but can't figure it out how exactly.

 

[moccasinus]

Also has all the raw materials in stock in order to start manufacturing it:

1 or more in stock means surplus, 0 - exact amount needed.

 

[moccasinus]

Ok, so far I've got it working for separate cells:
=IF(AND(L$3>0;SUMPRODUCT(COUNTIF('Sheet1'!$B$4:$B$830;">0"))=SUMPRODUCT(COUNTIFS('Sheet1'!$B$4:$B$830;">0";'Sheet1'!IS$4:IS$830;">=0")));TRUE;FALSE)

How can I refer to those ranges using Product1 and Week no. instead of marking it by hand?