conditional formatting between two tables

[Tody03]

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.

[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Table 1[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]table 2[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]Combined[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD="align: right"]100[/TD]
[TD][/TD]
[TD="class: xl65"]5 100[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD="align: right"]150[/TD]
[TD][/TD]
[TD="class: xl65"]0 150[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD="align: right"]120[/TD]
[TD][/TD]
[TD="class: xl65"]6 120[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD="align: right"]140[/TD]
[TD][/TD]
[TD="class: xl65"]3 140
[/TD]
[/TR]
</tbody>[/TABLE]

Thanks for your help

 

[Aryatect]

Hi, Please select the lines for table 3 say if here it is in Column C then selecting C2:C4 then go to conditional formatting and enter =$A2>0 (assuming Table1 is in Column A)

 

[Tody03]

Thanks Aryatect for your quick response. Your solution is working on one cell. My tables are 30X10 each can be even bigger. I need that one cell in table one will effect the parallel cell in table 3. My combined formula is =a1&k1.

 

[Aryatect]

Before applying conditional formatting you have to select all rows in combined table, if your table has heading then select Col2 to Col9999 and then apply =$A2>0

 

[Tody03]

your solution is effecting table 3 from the status of A2 only . That is not my case. Each cell in table 3 is should be effected effected from he parallel cell in table 1. For example If table 3 starts at a50 - a50 is effected by a1, b50 by b1 etc.

 

[Aryatect]

Sorry but I am not able to understand you, If your all the tables start from ROW 50 and go upto ROW 100, then in that case you will have to modify the formula to start from ROW 50 like =$A5>0. Below is the example on how this works:

https://drive.google.com/open?id=1fFxk79IS4Z35orG4mZB_UlL6ujcF0Eh9

 

[Tody03]

Maybe you did not understood me, but I managed to get my answer from you. Instead of =$a$5>0 i had to write =a5>0. In that way the condition changed according to the parallel cell.
Thanks

 

[Aryatect]

ohkk, good to know