Help with conditional formatting of a spreadsheet

**Oblit3ration** · 07-28-2009, 06:43 PM

Hey all,

First post here, hoping to get some help and advice for an idea I’m trying to make a reality.

I'm a massive golf fan, and I'm trying to create myself a spreadsheet to track my rounds of golf, scores, handicap etc.

One of the first things I'm trying to get working is that I want it to auto-adjust what holes I get shots on if and when my handicap changes.

This would work something like this:

I have a sheet with the course score card mapped out. Holes 1-18 etc with the stroke index of each hole (level of difficulty - i.e. hole 1 might be stroke index 14, hole 2 stroke index 6, hole 18 might be stroke index 18 etc etc)

I also have a sheet with my handicap cell which I can enter and change accordingly.
On this same sheet are my scores, with holes 1-18. The way I'd like it to work is that if my handicap is currently 8 holes that are stroke index 1 to 8 are given a red (or whatever colour) border. The rest are left alone.

If my Handicap changes to say 6, I enter 6 in the handicap cell and this automatically adjusts so that holes with a stroke index 1 to 6 are bordered in a colour.

Hopefully you get the idea. It should allow you to put in any handicap and automatically check what holes you get a shot on and then highlight them accordingly.

Realise this is a bit of an odd request, but whilst I'm not a beginner in the IT world I am a beginner with Excel and am most certainly a beginner with ANY programming that is required!

Many thanks in advance.

**prawer** · 07-28-2009, 07:17 PM

Use Conditional Formatting (under format>conditional formatting ...) after selecting the cells with the stroke indexes of individual holes.

Have the conditional formatting dialog point to the cell in which you've indicated your handicap, and set the conditional format to what you like.

**shg** · 07-28-2009, 08:59 PM

Welcome to the forum, Oblit3ration.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

**Oblit3ration** · 07-29-2009, 06:22 PM

Thanks Prawer, and apologies shg, title amended.

**martindwilson** · 07-29-2009, 06:51 PM

conditional format is on the home tab of excel 2007
you need to use the formula is option
click on a cell in column I then click conditional format/manage rules/edit rule to see whats in it.
a tutorial here
http://www.free-training-tutorial.co...ormatting.html