Excel question about keeping soccer scores between two teams, highlighting the winner on each game and etc.?
Question by Giorgos T: Excel question about keeping soccer scores between two teams, highlighting the winner on each game and etc.?
hi, i’m making an excel file where i record every game I’m playing with a friend on Pro evolution soccer. So, I’ve made two rows with our names on top, each team on each side and the scores in the middle. My question is this. How can i make it highlight the winner on each game. I want it to automatically compare the two values and then highlight the winner team. Furthermore i want it to add one point on another cell for every victory one of us is getting. I hope somebody will know me. Thanks
Best answer:
Answer by mark r
have a look at conditional formatting for the highlighting.
The Iff function should let you do your comparison and place a value in a cell.
You may want to look at Dsum() for adding the total number of goals etc
Give your answer to this question below!
