I need help automating this sheet. I want to highlight the winning team on the left, then have the losing teams automatically highlighted for every person. After that I want the total highlighted cells to be counted and output at the bottom for each person. Please see my example I hope I made sense....
