Highlighting Specific Cells In Another Table

[rackem12]

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

Home	Away	H-Points	A-Points	H-Result	A-Result
Afghanistan	Albania	0.12	0.62	L	W
Zimbabwe	Andorra	0.74	0.07	W	L
Zambia	Angola	0.47	0.22	W	L
Yemen	Anguilla	0.98	0.00	W	L
Wales	Antigua & Barbuda

<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>
</tbody>

Table 2

Rank	Team	Conf.	GP	W	L	T	GB	Win %	PF	PA	PT	PD	Rtg	RTG Diff
1	Brazil	CONMEBOL	6	6	0	0		1.000	5.41	0.10	0.49	5.31	1.0000
2	Colombia	CONMEBOL	6	6	0	0		1.000	5.33	0.14	0.53	5.19	0.9999	0.0000
3	Austria	Europe	7	7	0	0	-0.5	1.000	6.16	0.23	0.61	5.93	0.9999	0.0001
4	Chile	CONMEBOL	6	6	0	0		1.000	5.05	0.23	0.72	4.82	0.9998	0.0001
5	Italy	Europe	6	6	0	0		1.000	4.99	0.25	0.76	4.74	0.9997	0.0001

<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>
</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.

 

[Yongle]

thanks for your feedback