NCAA Tournament brackets

[Joseph Horling]

Hi,

I made an NCAA tournament bracket in excel. I used text boxes to fill in the teams that have won their games. I would like to know if there is a formula or a code that I can use to color the boxes when one team wins. I would like to see a box turn red when I use the lower seeded team or when a box turn blue when the higher seeded team wins. When I type in Duke it would turn blue, or when I type in Minnesota it would turn red. I don't want to use shape fill color for everyone. I haven't quite finished the brackets yet. Thanks for you help.... Joe, Michigan/

 

[GraH - Guido]

Hi Joseph Horling,
Another way of doing, might be making a chart (Scatter).
I did not have the time to finish it all off and to organize the data much better, but the basic rough idea is there.

 

[Joseph Horling]

great, thanks GraH Guido. I'll work on that way. Thanks for your response.

 

[Peter Bartholomew]

2018 World Cup Russia Free Predictor Template | Spreadsheet1

Free interactive spreadsheet to predict the World Cup 2018 finalists. Keep track of the FIFA game scores and fill in your predictions in Excel!

www.spreadsheet1.com

The link is to a spreadsheet I co-authored. The knockout stage uses a pattern of cells together with superposed pictures of national flags to present the sort of information you have.

 

[GraH - Guido]

Nice one Peter, I saw that one before and was looking for it to suggest here, but I could not recall the source at all.