So I have a spreadsheet and I am trying to highlight the team name in the 2nd table, based on the next blank cell in the first table. What I am hoping for is that after i put in the score in table 1, it will change the highlight in table 2 to the next matchup. This will allow me to better see the standings move as I input each result.
Example:
Table1
<colgroup><col style="mso-width-source:userset;mso-width-alt:5319; width:112pt" width="150" span="2"> <col style="mso-width-source:userset;mso-width-alt:2190; width:46pt" width="62" span="2"> <col style="mso-width-source:userset;mso-width-alt:2190; width:46pt" width="62" span="2"> </colgroup><tbody>
[TD="class: xl63, width: 150"]Home
[/TD]
[TD="class: xl63, width: 150"]Away[/TD]
[TD="class: xl65, width: 62"]H-Points[/TD]
[TD="class: xl65, width: 62"]A-Points[/TD]
[TD="class: xl63, width: 62"]H-Result[/TD]
[TD="class: xl63, width: 62"]A-Result[/TD]
[TD="class: xl63"]Afghanistan
[/TD]
[TD="class: xl63"]Albania[/TD]
[TD="class: xl65"]0.12[/TD]
[TD="class: xl65"]0.62[/TD]
[TD="class: xl63"]L[/TD]
[TD="class: xl63"]W[/TD]
[TD="class: xl63"]Zimbabwe
[/TD]
[TD="class: xl63"]Andorra[/TD]
[TD="class: xl65"]0.74[/TD]
[TD="class: xl65"]0.07[/TD]
[TD="class: xl63"]W[/TD]
[TD="class: xl63"]L[/TD]
[TD="class: xl63"]Zambia
[/TD]
[TD="class: xl63"]Angola[/TD]
[TD="class: xl65"]0.47[/TD]
[TD="class: xl65"]0.22[/TD]
[TD="class: xl63"]W[/TD]
[TD="class: xl63"]L[/TD]
[TD="class: xl63"]Yemen
[/TD]
[TD="class: xl63"]Anguilla[/TD]
[TD="class: xl65"]0.98[/TD]
[TD="class: xl65"]0.00[/TD]
[TD="class: xl63"]W[/TD]
[TD="class: xl63"]L[/TD]
[TD="class: xl63"]Wales
[/TD]
[TD="class: xl63"]Antigua & Barbuda[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
</tbody>
Table 2
<colgroup><col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:4864;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:4949;width:104pt" width="139"> <col style="mso-width-source:userset;mso-width-alt:1336; width:28pt" width="38" span="2"> <col style="mso-width-source:userset;mso-width-alt:796; width:17pt" width="22" span="2"> <col style="mso-width-source:userset;mso-width-alt:1336;width:28pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1706;width:36pt" width="48"> <col style="mso-width-source:userset;mso-width-alt:1166; width:25pt" width="33" span="2"> <col style="mso-width-source:userset;mso-width-alt:1934; width:41pt" width="54" span="2"> <col style="mso-width-source:userset;mso-width-alt:2360;width:50pt" width="66"> <col style="mso-width-source:userset;mso-width-alt:2190;width:46pt" width="62"> </colgroup><tbody>
[TD="class: xl65, width: 38"]Rank
[/TD]
[TD="class: xl65, width: 137"]Team
[/TD]
[TD="class: xl65, width: 139"]Conf.[/TD]
[TD="class: xl65, width: 38"]GP[/TD]
[TD="class: xl65, width: 38"]W[/TD]
[TD="class: xl65, width: 22"]L[/TD]
[TD="class: xl65, width: 22"]T[/TD]
[TD="class: xl68, width: 38"]GB[/TD]
[TD="class: xl69, width: 48"]Win %[/TD]
[TD="class: xl67, width: 33"]PF[/TD]
[TD="class: xl67, width: 33"]PA[/TD]
[TD="class: xl67, width: 54"]PT[/TD]
[TD="class: xl67, width: 54"]PD[/TD]
[TD="class: xl70, width: 66"]Rtg[/TD]
[TD="class: xl70, width: 62"]RTG Diff[/TD]
[TD="class: xl65"]1
[/TD]
[TD="class: xl65"]Brazil
[/TD]
[TD="class: xl65"]CONMEBOL[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1.000[/TD]
[TD="class: xl67"]5.41[/TD]
[TD="class: xl67"]0.10[/TD]
[TD="class: xl67"]0.49[/TD]
[TD="class: xl67"]5.31[/TD]
[TD="class: xl70"]1.0000[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]Colombia
[/TD]
[TD="class: xl65"]CONMEBOL[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1.000[/TD]
[TD="class: xl67"]5.33[/TD]
[TD="class: xl67"]0.14[/TD]
[TD="class: xl67"]0.53[/TD]
[TD="class: xl67"]5.19[/TD]
[TD="class: xl70"]0.9999[/TD]
[TD="class: xl70"]0.0000[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]Austria
[/TD]
[TD="class: xl65"]Europe[/TD]
[TD="class: xl65"]7[/TD]
[TD="class: xl65"]7[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl68"]-0.5[/TD]
[TD="class: xl69"]1.000[/TD]
[TD="class: xl67"]6.16[/TD]
[TD="class: xl67"]0.23[/TD]
[TD="class: xl67"]0.61[/TD]
[TD="class: xl67"]5.93[/TD]
[TD="class: xl70"]0.9999[/TD]
[TD="class: xl70"]0.0001[/TD]
[TD="class: xl65"]4[/TD]
[TD="class: xl65"]Chile[/TD]
[TD="class: xl65"]CONMEBOL[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1.000[/TD]
[TD="class: xl67"]5.05[/TD]
[TD="class: xl67"]0.23[/TD]
[TD="class: xl67"]0.72[/TD]
[TD="class: xl67"]4.82[/TD]
[TD="class: xl70"]0.9998[/TD]
[TD="class: xl70"]0.0001[/TD]
[TD="class: xl65"]5[/TD]
[TD="class: xl65"]Italy[/TD]
[TD="class: xl65"]Europe[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1.000[/TD]
[TD="class: xl67"]4.99[/TD]
[TD="class: xl67"]0.25[/TD]
[TD="class: xl67"]0.76[/TD]
[TD="class: xl67"]4.74[/TD]
[TD="class: xl70"]0.9997[/TD]
[TD="class: xl70"]0.0001[/TD]
</tbody>
As I stated, My goal is that Wales and Antigua & Barbuda will be highlighted in table 2, but once I input their scores, it will automatically highlight the next matchup in the standings table.
Thanks in advance.
Example:
Table1
<colgroup><col style="mso-width-source:userset;mso-width-alt:5319; width:112pt" width="150" span="2"> <col style="mso-width-source:userset;mso-width-alt:2190; width:46pt" width="62" span="2"> <col style="mso-width-source:userset;mso-width-alt:2190; width:46pt" width="62" span="2"> </colgroup><tbody>
[TD="class: xl63, width: 150"]Home
[/TD]
[TD="class: xl63, width: 150"]Away[/TD]
[TD="class: xl65, width: 62"]H-Points[/TD]
[TD="class: xl65, width: 62"]A-Points[/TD]
[TD="class: xl63, width: 62"]H-Result[/TD]
[TD="class: xl63, width: 62"]A-Result[/TD]
[TD="class: xl63"]Afghanistan
[/TD]
[TD="class: xl63"]Albania[/TD]
[TD="class: xl65"]0.12[/TD]
[TD="class: xl65"]0.62[/TD]
[TD="class: xl63"]L[/TD]
[TD="class: xl63"]W[/TD]
[TD="class: xl63"]Zimbabwe
[/TD]
[TD="class: xl63"]Andorra[/TD]
[TD="class: xl65"]0.74[/TD]
[TD="class: xl65"]0.07[/TD]
[TD="class: xl63"]W[/TD]
[TD="class: xl63"]L[/TD]
[TD="class: xl63"]Zambia
[/TD]
[TD="class: xl63"]Angola[/TD]
[TD="class: xl65"]0.47[/TD]
[TD="class: xl65"]0.22[/TD]
[TD="class: xl63"]W[/TD]
[TD="class: xl63"]L[/TD]
[TD="class: xl63"]Yemen
[/TD]
[TD="class: xl63"]Anguilla[/TD]
[TD="class: xl65"]0.98[/TD]
[TD="class: xl65"]0.00[/TD]
[TD="class: xl63"]W[/TD]
[TD="class: xl63"]L[/TD]
[TD="class: xl63"]Wales
[/TD]
[TD="class: xl63"]Antigua & Barbuda[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
</tbody>
Table 2
<colgroup><col style="mso-width-source:userset;mso-width-alt:1365;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:4864;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:4949;width:104pt" width="139"> <col style="mso-width-source:userset;mso-width-alt:1336; width:28pt" width="38" span="2"> <col style="mso-width-source:userset;mso-width-alt:796; width:17pt" width="22" span="2"> <col style="mso-width-source:userset;mso-width-alt:1336;width:28pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1706;width:36pt" width="48"> <col style="mso-width-source:userset;mso-width-alt:1166; width:25pt" width="33" span="2"> <col style="mso-width-source:userset;mso-width-alt:1934; width:41pt" width="54" span="2"> <col style="mso-width-source:userset;mso-width-alt:2360;width:50pt" width="66"> <col style="mso-width-source:userset;mso-width-alt:2190;width:46pt" width="62"> </colgroup><tbody>
[TD="class: xl65, width: 38"]Rank
[/TD]
[TD="class: xl65, width: 137"]Team
[/TD]
[TD="class: xl65, width: 139"]Conf.[/TD]
[TD="class: xl65, width: 38"]GP[/TD]
[TD="class: xl65, width: 38"]W[/TD]
[TD="class: xl65, width: 22"]L[/TD]
[TD="class: xl65, width: 22"]T[/TD]
[TD="class: xl68, width: 38"]GB[/TD]
[TD="class: xl69, width: 48"]Win %[/TD]
[TD="class: xl67, width: 33"]PF[/TD]
[TD="class: xl67, width: 33"]PA[/TD]
[TD="class: xl67, width: 54"]PT[/TD]
[TD="class: xl67, width: 54"]PD[/TD]
[TD="class: xl70, width: 66"]Rtg[/TD]
[TD="class: xl70, width: 62"]RTG Diff[/TD]
[TD="class: xl65"]1
[/TD]
[TD="class: xl65"]Brazil
[/TD]
[TD="class: xl65"]CONMEBOL[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1.000[/TD]
[TD="class: xl67"]5.41[/TD]
[TD="class: xl67"]0.10[/TD]
[TD="class: xl67"]0.49[/TD]
[TD="class: xl67"]5.31[/TD]
[TD="class: xl70"]1.0000[/TD]
[TD="class: xl70"][/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]Colombia
[/TD]
[TD="class: xl65"]CONMEBOL[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1.000[/TD]
[TD="class: xl67"]5.33[/TD]
[TD="class: xl67"]0.14[/TD]
[TD="class: xl67"]0.53[/TD]
[TD="class: xl67"]5.19[/TD]
[TD="class: xl70"]0.9999[/TD]
[TD="class: xl70"]0.0000[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]Austria
[/TD]
[TD="class: xl65"]Europe[/TD]
[TD="class: xl65"]7[/TD]
[TD="class: xl65"]7[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl68"]-0.5[/TD]
[TD="class: xl69"]1.000[/TD]
[TD="class: xl67"]6.16[/TD]
[TD="class: xl67"]0.23[/TD]
[TD="class: xl67"]0.61[/TD]
[TD="class: xl67"]5.93[/TD]
[TD="class: xl70"]0.9999[/TD]
[TD="class: xl70"]0.0001[/TD]
[TD="class: xl65"]4[/TD]
[TD="class: xl65"]Chile[/TD]
[TD="class: xl65"]CONMEBOL[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1.000[/TD]
[TD="class: xl67"]5.05[/TD]
[TD="class: xl67"]0.23[/TD]
[TD="class: xl67"]0.72[/TD]
[TD="class: xl67"]4.82[/TD]
[TD="class: xl70"]0.9998[/TD]
[TD="class: xl70"]0.0001[/TD]
[TD="class: xl65"]5[/TD]
[TD="class: xl65"]Italy[/TD]
[TD="class: xl65"]Europe[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl68"][/TD]
[TD="class: xl69"]1.000[/TD]
[TD="class: xl67"]4.99[/TD]
[TD="class: xl67"]0.25[/TD]
[TD="class: xl67"]0.76[/TD]
[TD="class: xl67"]4.74[/TD]
[TD="class: xl70"]0.9997[/TD]
[TD="class: xl70"]0.0001[/TD]
</tbody>
As I stated, My goal is that Wales and Antigua & Barbuda will be highlighted in table 2, but once I input their scores, it will automatically highlight the next matchup in the standings table.
Thanks in advance.