Selected Answer
Dr Liss
Not sure I understand your question but conditional formatting can be used to highlight each Friday for the 5 teams in sequence.
In the attached file, I've added a new rule (based on a formula) to cell B3:
=IF(MOD(COLUMN()-2 - (ROW()-3)*7, 35)=0,1,0)
where the subtracted numbers make B3 in position 0,0 and the
7 makes a difference of 7 (days) between a team and the one in the row above. The
35 (7*5) is the divisor for the MOD worksheet function and gives the TRUE result once every 5 eeeks per team.
I've then changed the "applies to" to $B$3:$BG$7 (and added some extra date headings to show it loops around so the first team get "Fun Time" after team 5).
Hope this is what you need.