Fantasy Football Macro

[TonyforVBA]

Hopfully people will see what I am trying to do here from the attached.
But basically I want to set up conditional formating on the 'Macro' sheet so that each week it will base the formating of the cells against the Home & Away form of both teams plaing in each match.

Would anybody have an ideas what might be the best way to go about this?


ps. SO happy the football is back!!