Highlight yellow on stock gaps

Highlight yellow where stock is Zero
While stock on others on the same line are greather than Zero

In the Attached file I have done those manually

Macro to read data at 25,ooo rows

If the rest of the Zero can be pink , It will be good ,
Since Conditional formatting not doing that because some
of Zero Stock is in Yellow