Using Excel for Golf Skins

Hi Vidcity,

Let's say you have golfer names in column A (A2:A100). In column B you have each of their scores for hole #1, e.g. 3, 4, 3, 5, 4, 5, 3, etc.

Select B2:B100 and click Conditional Formatting. Select New Rule..., then select 'Use a formula to determine...'. In the formula box below that, type:

=AND(COUNTIF($B$2:$B$100,B2)=1,B2=MIN($B$2:$B$100))

Adjust your actual ranges as necessary. Click the Format... button, and on the Fill tab select yellow. Click OK twice to return to your sheet.

Any "skins" will now be highlighted in yellow for that column. If you wanted to do that for all of the hole #'s (e.g columns B:S) select those cells and use this slightly modified formula as the conditional format:

=AND(COUNTIF(B$2:B$100,B2)=1,B2=MIN(B$2:B$100))

Again, adjust your ranges as needed. Hope that helps!