Excel on the Golf Course

golficon I’d need wider columns to hold my golf scores, but this Excel template for golf scores might help you keep track of your annual progress.

golfscores01 

There’s also an annual summary sheet, that calculates your average score and best score for the year.

golfscores01c

Conditional Formatting for Scores

The golf scores template uses conditional formatting to highlight the holes where you shot par or below par, so you can see at a glance how things are going. You enter the course pars on the Summary sheet, and the conditional formatting is on the Scores sheet.

golfscores01d

Because conditional formatting won’t allow you to refer to cells on another sheet, I named cell B8 as CoursePar, and use that name in the conditional formatting formulas. For example, the formula for par is:

=B2=OFFSET(CoursePar,0,COLUMN()-1)

golfscores04

Download the Golf Scores Template

You can download the zipped sample Excel template for golf scores, which is in Excel 2003 format. There are more screen shots and details on the Excel Template – Golf Scores page at the Contextures website.

______________

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *