statsman
Active member
- Local time
- Today, 04:45
- Joined
- Aug 22, 2004
- Messages
- 2,088
I am doing an NFL pool. This pool calls for each participant to select only one winner each week.
If the team selected loses, the participant is eliminated.
As there are as many as 16 games each week, I would like to highlight the players and teams that lost.
Example: Player 1 chose Baltimore as his weekly selection. Baltimore is playing in Game #5 that week against the Bengals. The Bengals win.
It seems that going through multiple games each week is not something the standard conditional formatting function was designed for.
Is there a method of doing this?
If the team selected loses, the participant is eliminated.
As there are as many as 16 games each week, I would like to highlight the players and teams that lost.
Example: Player 1 chose Baltimore as his weekly selection. Baltimore is playing in Game #5 that week against the Bengals. The Bengals win.
It seems that going through multiple games each week is not something the standard conditional formatting function was designed for.
Is there a method of doing this?