<p>Hello,</p>
<p> </p>
<p>I have a crosstable like:</p>
<p> </p>
<p> date1 date2 date3 date 4</p>
<p>product1 5 6 9 10</p>
<p>product2 4 7 4 11</p>
<p>product3 42 12 5 6</p>
<p> </p>
<p> </p>
<p>It is possible to highlight a cell in row2 based on condition like:</p>
<p>if (value from row where product=product1 and column2 - value from row where product=product1 and column1) > 0 and</p>
<p>(value from row where product!=product1 and column2 - value from row where product=product1 and column1) < 0</p>
<p>) then set background color for value in row where product!=product1 and column2</p>
<p> </p>
<p>?</p>
<p> </p>
<p>Regards,</p>
<p> </p>
<p>Adam</p>
<p> </p>
