Newbie on the forum.
I have set up a nice spreadsheet to where I can see who has won the hole by using conditional formatting to highlight the cells equal to minimum value, which is located in row 45. I have two questions...
1. How do I UNHIGHLIGHT the cells if there are duplicate lowest scores (minimum values)?
2. Now I'd like to show the payouts for this spreadsheet. I have 10 teams putting in $20 for skins, coming out to $11.11 for each hole, this is located in cell D43. In case you're unaware of how skins are played, you have to win the hole out right, so if there is a duplicate score on Hole 1 then there is no winner and the money for Hole 1 ($11.11) moves over to Hole 2 making the skin for Hole 2 $22.22, so on and so forth.
Any help is very much appreciated!
Thanks!
I have set up a nice spreadsheet to where I can see who has won the hole by using conditional formatting to highlight the cells equal to minimum value, which is located in row 45. I have two questions...
1. How do I UNHIGHLIGHT the cells if there are duplicate lowest scores (minimum values)?
2. Now I'd like to show the payouts for this spreadsheet. I have 10 teams putting in $20 for skins, coming out to $11.11 for each hole, this is located in cell D43. In case you're unaware of how skins are played, you have to win the hole out right, so if there is a duplicate score on Hole 1 then there is no winner and the money for Hole 1 ($11.11) moves over to Hole 2 making the skin for Hole 2 $22.22, so on and so forth.
Any help is very much appreciated!
Thanks!