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

Kemahiran: Excel

Lihat lagi: horizontal line example, change website value, excel automatic change color depending value, change colour value red value green excel, Value, turn in to, product colour change, in stock, green delivery, go stock, colour, change red, add colour, need someone bid item, excel colour, depending, easy tab, stock spreadsheet excel, item sold, stock excel spreadsheet

Tentang Majikan:
( 102 ulasan ) Alexandria, United Kingdom

ID Projek: #303650

Dianugerahkan kepada:


VBA developer since 1997. Part of this job requires some VBA coding. Can do. Regards, Svet. P.S. You shall have it today/tonight.

$30 USD dalam 0 hari
(56 Ulasan)

3 pekerja bebas membida secara purata $30 untuk pekerjaan ini


Hi. Please see PM. Thanks!

$30 USD dalam sehari
(0 Ulasan)

Respected Sir, I am ready to work for you with sincere effort to your fullest satisfaction. Will be expecting to work for you. I have hands of full experience in Excel and i will complete your work more than u expectat Lagi

$30 USD dalam sehari
(0 Ulasan)