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.