I would want to highlight cells on each Friday of the week for those teams in the same order as shown in the spreadsheet below. The cells colored red with text "Fun Time" should be applied as and when the conditional formatting is set to a formula.
Is it possible through conditional formatting alone?