Change horizontal colum colour automatically depending on value in verticle columb

Please see attched spreadsheet The horizontal columbs are all green, I need someone to make them turb red when a value of 1 or more is entered into the "sold" verticle colum, and change back to green if a value of one or more is entered into "in stock" or "waiting delivery" For example in the first tab, the first product on line 3 has one item sold, so the columb colour should be red becuase it will have a value of one or more in the sold colum. If I add a positive value to in stock or waiting delivery, the colour should turn back to green. Small easy project for someone, the project will go to the service provider who can do the project in the least time with the lowest bid