How to select table cell in the if function in VBA excel?

I have a stock management table in excel sheet. Demo here: Demo photo of this table

I want to create a code in VBA that comes In stock column and will test the whole cells. If any cell.Value < 2 and >0 then go to 4 cells backward take the value of this cell and show a message box "backward cell.value and stock not available".

---

I tired to make this please help me.