Auto Cell Colour

[BullseyeThor]

Hi All

I'm trying to put a info sheet to let people know about current stocks and time we have left of each product.

I have estimated weeks of stock left as shown below (Cover in stock, cover on way, factory cover, store cover.

I want the sheet to colour in cells along a row depending on how many weeks are left of each product but at the same time I want the orther categories to be added on after the first colour on the same row. Hope that makes sense.

I have pasted a sample below.

<table style="width: 2173pt; border-collapse: collapse;" border="0" cellSpacing="0" cellPadding="0" width="2890"> <colgroup><col style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;" width="84"> <col style="width: 146pt; mso-width-source: userset; mso-width-alt: 7131;" width="195"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" span="2" width="64"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" span="4" width="78"> <col style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;" width="88"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" span="2" width="78"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" width="78"> <col style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;" width="78"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1682;" span="3" width="46"> <col style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;" span="4" width="49"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" span="4" width="51"> <col style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;" width="48"> <col style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;" span="4" width="48"> <col style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" span="4" width="53"> <col style="width: 35pt; mso-width-source: userset; mso-width-alt: 1718;" span="4" width="47"> <col style="width: 32pt; mso-width-source: userset; mso-width-alt: 1572;" span="5" width="43"> <col style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;" span="2" width="50"> <col style="width: 209pt; mso-width-source: userset; mso-width-alt: 10166;" width="278"> <tbody><tr style="height: 45pt;" height="60"> <td style="border: 0.5pt solid windowtext; width: 63pt; height: 45pt; background-color: rgb(149, 179, 215);" class="xl63" height="60" width="84">Sku</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 146pt; background-color: rgb(149, 179, 215);" class="xl64" width="195">Product</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 48pt; background-color: rgb(149, 179, 215);" class="xl65" width="64">Size</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 48pt; background-color: rgb(149, 179, 215);" class="xl65" width="64">Supplier</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 59pt; background-color: rgb(149, 179, 215);" class="xl65" width="78">Avg Sales - Cases</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 59pt; background-color: rgb(149, 179, 215);" class="xl65" width="78">In Stock - Cases</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 59pt; background-color: rgb(149, 179, 215);" class="xl65" width="78">On Way - Cases</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 59pt; background-color: rgb(149, 179, 215);" class="xl65" width="78">Store Stock - Cases</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 66pt; background-color: rgb(149, 179, 215);" class="xl65" width="88">Factory Stock - Cases</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 59pt; background-color: yellow;" class="xl71" width="78">MTD Cover in Stock</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 59pt; background-color: rgb(0, 176, 80);" class="xl78" width="78">On Way Stock cover</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 59pt; background-color: rgb(149, 179, 215);" class="xl65" width="78">Factory Stock - Cover</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 59pt; background-color: rgb(247, 150, 70);" class="xl73" width="78">Store Cover</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 35pt; background-color: rgb(149, 179, 215);" class="xl69" width="46">16-Jan</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 35pt; background-color: rgb(149, 179, 215);" class="xl69" width="46">23-Jan</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 35pt; background-color: rgb(149, 179, 215);" class="xl69" width="46">30-Jan</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 37pt; background-color: rgb(149, 179, 215);" class="xl69" width="49">06-Feb</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 37pt; background-color: rgb(149, 179, 215);" class="xl69" width="49">13-Feb</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 37pt; background-color: rgb(149, 179, 215);" class="xl69" width="49">20-Feb</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 37pt; background-color: rgb(149, 179, 215);" class="xl69" width="49">27-Feb</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 38pt; background-color: rgb(149, 179, 215);" class="xl69" width="51">05-Mar</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 38pt; background-color: rgb(149, 179, 215);" class="xl69" width="51">12-Mar</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 38pt; background-color: rgb(149, 179, 215);" class="xl69" width="51">19-Mar</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 38pt; background-color: rgb(149, 179, 215);" class="xl69" width="51">26-Mar</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 36pt; background-color: rgb(149, 179, 215);" class="xl69" width="48">02-Apr</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 36pt; background-color: rgb(149, 179, 215);" class="xl69" width="48">09-Apr</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 36pt; background-color: rgb(149, 179, 215);" class="xl69" width="48">16-Apr</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 36pt; background-color: rgb(149, 179, 215);" class="xl69" width="48">23-Apr</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 36pt; background-color: rgb(149, 179, 215);" class="xl69" width="48">30-Apr</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 40pt; background-color: rgb(149, 179, 215);" class="xl69" width="53">07-May</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 40pt; background-color: rgb(149, 179, 215);" class="xl69" width="53">14-May</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 40pt; background-color: rgb(149, 179, 215);" class="xl69" width="53">21-May</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 40pt; background-color: rgb(149, 179, 215);" class="xl69" width="53">28-May</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 35pt; background-color: rgb(149, 179, 215);" class="xl69" width="47">04-Jun</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 35pt; background-color: rgb(149, 179, 215);" class="xl69" width="47">11-Jun</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 35pt; background-color: rgb(149, 179, 215);" class="xl69" width="47">18-Jun</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 35pt; background-color: rgb(149, 179, 215);" class="xl69" width="47">25-Jun</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 32pt; background-color: rgb(149, 179, 215);" class="xl69" width="43">02-Jul</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 32pt; background-color: rgb(149, 179, 215);" class="xl69" width="43">09-Jul</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 32pt; background-color: rgb(149, 179, 215);" class="xl69" width="43">16-Jul</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 32pt; background-color: rgb(149, 179, 215);" class="xl69" width="43">23-Jul</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 32pt; background-color: rgb(149, 179, 215);" class="xl69" width="43">30-Jul</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 38pt; background-color: rgb(149, 179, 215);" class="xl69" width="50">06-Aug</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 38pt; background-color: rgb(149, 179, 215);" class="xl69" width="50">13-Aug</td> <td style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; width: 209pt; background-color: rgb(149, 179, 215);" class="xl69" width="278">Replacement product agreed and ordered</td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 15pt; background-color: transparent;" class="xl79" height="20">000000</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74">Product 1</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl66">H x W</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl66"></td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl66">540</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">1356</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">400</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">2100</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">150</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">10.04</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">2.96</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">1.11</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">15.56</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: yellow;" class="xl80"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(0, 176, 80);" class="xl81"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(0, 176, 80);" class="xl81"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(0, 176, 80);" class="xl81"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(0, 112, 192);" class="xl83"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl76"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl76"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 15pt; background-color: transparent;" class="xl79" height="20">000000</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74">Product 2</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl66">H x W</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl66"></td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl66">1100</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">500</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">800</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">600</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">0</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">1.82</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">2.91</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">0.00</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">2.18</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(0, 176, 80);" class="xl82"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(0, 176, 80);" class="xl82"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(0, 176, 80);" class="xl82"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(255, 153, 51);" class="xl77"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(255, 153, 51);" class="xl77"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> </tr> <tr style="height: 15pt;" height="20"> <td style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext; height: 15pt; background-color: transparent;" class="xl79" height="20">000000</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74">Product 3 </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl66">H x W</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl66"></td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl66">260</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">425</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">214</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">1469</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl72">0</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">6.54</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">3.29</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">0.00</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl70">22.60</td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: yellow;" class="xl75"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(0, 176, 80);" class="xl82"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(0, 176, 80);" class="xl82"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(0, 176, 80);" class="xl82"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: rgb(247, 150, 70);" class="xl85"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: rgb(247, 150, 70);" class="xl84"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: windowtext; background-color: transparent;" class="xl76"> </td> <td style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black; background-color: transparent;" class="xl74"> </td> </tr></tbody></table>
Where the Yellow ends I want the next specified category to start from.

Hope someone understands what I mean and can help me.

Thanks

 

[Andrew Poulsom]

I'm thinking that you can use conditional formatting, but what version of Excel do you have?

 

[Flank]

This seems like it can be solved with a simple conitional format

Reference this thread.
http://www.mrexcel.com/forum/showthread.php?p=2997162#post2997162

I am loosing you when you state

I want the orther categories to be added on after the first colour on the same row