I was wondering if anybody could help. I am creating a spreadsheet for a football pool that me and my friends participate in each week of the nfl season. What I am having trouble with is I would like to have a list of each nfl team playing that week, with the table of everybody's picks for that given week. In the list of the teams on the side of the table, I would like to highlight the winning team of each game once, then it would go through the table and highlight that team automatically every time it appears in the table, so I don't have to highlight each box individually where it appears. So, say if Pittsburgh wins, i could highlight Pittsburgh once, then everyone who picked Pittsburgh would automatically have their Pittsburgh box highlighted in the same color Pittsburgh was highlighted in in my teams list. I hope I explained this right and thanks in advance for any help any of you might be able to lend!