I have two tables in one sheet. I combine parallel data from both of them into a third table.
If a cell in table one >0 I want to color the parallel cell in table 3.
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks for your help
If a cell in table one >0 I want to color the parallel cell in table 3.
Table 1 | table 2 | Combined | ||
5 | 100 | 5 100 | ||
0 | 150 | 0 150 | ||
6 | 120 | 6 120 | ||
3 | 140 | 3 140 |
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>
Thanks for your help