#### Golf scores

```I am trying to change the cell colour depending on the input against the
actual Par .
ie Column A = the actual par for each hole, Column B is the actual score

if the input for cell B2 is greater than cell A1 the cell = Red
""""  """"""    """" """       = to              """   """ """"     = Green
""""  """"""    """"""""      less      """"  """  """ """"      = Purple

Many thanks

```
 0
Utf
5/29/2010 12:49:01 PM
excel.newusers 15348 articles. 0 followers.

2 Replies
425 Views

Similar Articles

[PageSpeed] 21

```What version of Excel are you using?

--
Biff
Microsoft Excel MVP

"Pop Sturman" <Pop Sturman@discussions.microsoft.com> wrote in message
news:F6ECB6A0-6439-42A6-B32D-F685E0E92443@microsoft.com...
>I am trying to change the cell colour depending on the input against the
> actual Par .
> ie Column A = the actual par for each hole, Column B is the actual score
>
>
> if the input for cell B2 is greater than cell A1 the cell = Red
> """"  """"""    """" """       = to              """   """ """"     =
> Green
> """"  """"""    """"""""      less      """"  """  """ """"      = Purple
>
> Many thanks
>
>
>

```
 0
T
5/29/2010 2:19:46 PM
```Use conditional formatting...

See http://www.cpearson.com/excel/cformatting.htm

"Pop Sturman" wrote:

> I am trying to change the cell colour depending on the input against the
> actual Par .
> ie Column A = the actual par for each hole, Column B is the actual score
>
>
> if the input for cell B2 is greater than cell A1 the cell = Red
> """"  """"""    """" """       = to              """   """ """"     = Green
> """"  """"""    """"""""      less      """"  """  """ """"      = Purple
>
> Many thanks
>
>
>
```
 0
Utf
5/31/2010 12:35:01 PM

Similar Artilces:

How can I total the top 9 scores of 12 weeks in a sporting contest
I need to keep track of the scores in a quiz for 12 weeks running, then total each contestant's best 9 scores. Is there any way to sum a column, automaticaly ignoring the 3 worst scores? =SUM(LARGE(A1:A12,ROW(1:9)) it is an array formula, so commit it with Ctrl-Shift-Enter. -- HTH Bob Phillips "Vance Burton" <Vance Burton@discussions.microsoft.com> wrote in message news:914AED28-4FC3-42EF-AB5A-D8943147F795@microsoft.com... > I need to keep track of the scores in a quiz for 12 weeks running, then total > each contestant's best 9 scores. > > Is ther...

Weekly Score
I have a calendar where the user picks a range of dates to see a weekly or monthly score. However I don't want the dates to show because it spikes out the scores for each day. If a user has 12 items that were qa'd during the week of 7//16 and 7/20. I want to be able to pick those dates on the calendar but for the report to say 12 and score not 7/16 2 95% 7/17 3 100% 7/18 2 88% 7/19 4 72% and 7/20 1 100% my code says : DoCmd.OpenReport "RWeeklySummary", acViewPreview, , "[DateQA] between #" & Me.txtbegindate & "# and #" & Me.txtenddate &...

Golf
My boss has asked me to create a schedule for their golf team. How can I do this in excel . 12 players - 3 Groups of 4 6 days How can I randomly select players into teams so that no one can play with the same people. Hope this makes sense. -- All help much appreciated. Thanks Hi! I think your specification is a bit ambitious. On each day, player A plays with 3 others. If, every day, he were to play with a different set of 3 ("no one ca play with the same people"), then he would use up 18 other player during the 6 days. There are only 11. Maybe they will play as pairs again...

Golf Scores
Hi I would like to know what kind of formula I will use to get a point score like +2 or -2 instead of a regular score but still using handicaps. Example a player with a 4 handicap on the third handicap hole gets a stroke so if he scores a 4 he would then have a 3 or birdie and get awarded 4 points instead of the 3. This would be modeled after the stableford system but using handicap also. Thanks in advance Karl ...

Golf Handicaps
Does anyone know how to obtain an Excel worksheet that calculates golf handicaps? I would try to develop my own but don't know the mysteries of golf handicap calculation. D Several years back I posted code to do this. You can probably find it on Google. I had no idea how to calculate a golf handicap, either, but a quick Google search revealed all. On Sat, 10 Sep 2005 13:14:14 +0000 (UTC), "David Clark" <shots4league-oneday@yahoo.co.uk> wrote: >Does anyone know how to obtain an Excel worksheet that calculates golf >handicaps? I would try to develop my own ...

Final Results from 1 or 2 scores
i have made a report that shows the scores and placings for contestants. Some events have 2 sets of scores and so have two final results which get added togeter and then divided by 2 to give a final percentage in the final mark Box. Then sometimes the same event has only 1 set of scores and 1 result and so the report needs to reflect result 1 as the Final percentage eg Place Contestants name Result 1 Result2 Final mark -- 1 Betty Boo 56% 75% 65.5% 1 Betty Boo 56% ...

hello, I need a formula. How can you make a number in a spreadsheet equal a different number. Here's the skinny: Par equals zero (not higher or below par) Birdie equals -1...so our event has pars worth 2 points birdies worth 4. I have entered all the scores and a coinciding table with the reference to par -1, +2, etc- now I want a table that converts that number to the coinciding points...thanks in advance -- GOLFER ------------------------------------------------------------------------ GOLFER's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23859 View thi...

Extracting golf score data
I have created a database to hold golf scores. The setup is as follows; tblCourse CourseID Name Address etc. tblCourseDetails CourseID TeeID Hole Par Yardage Handicap tblRounds RoundID CourseID GolferID etc tblRoundDetails RoundID Hole Score I am trying to query for all holes with the par = 3 and have all the scores for those par 3 holes. I will do the same for par 4 and par5s as well. I will use this as the basis for a report to show average scores on each of the holes. Each time I try to create a query I get results that show multiple entries or entries that are not from the par ...

Golf averages
There are 24 players in my golf league. I would like to get a running average of the last scores midway thru the season which runs for 20 weeks. I need the average of the last 8 scores submitted and not just an average of the last 8 weeks which could have one or more missing scores. 51 52 49 46 42 43 43 45 43 45 47 39 44 45 47 50 Hi! Try this entered as array using the key combo of CTRL,SHIFT,ENTER: =AVERAGE(A100:INDEX(A1:A100,LARGE(IF(A1:A100<>"",ROW(A1:A100)),8))) Use a big enough range to cover any future entries! Biff "Golf Averages" <GolfAverages@...

Sort winners of a golf tournament two ways
In a golf tournament, we have two groups of winners. One group is those players with the lowest gross scores. The second group is those players with the lowest net (gross minus handicap) scores. In the example, 3 players would be rewarded for their highest finish, be it gross or net. They cannot win a prize in both categories. Example: Name Hdc Gross Scr Net Scr Gross Rank Net Rank Bob 12 87 75 6 6 Carl 6 78 72 2 4 Ed 17 ...

Rank scores formula #2
Hi to all I would really like to enhance a formula: In bridge (the game) the raw scores are ranked and a value assigned where the top score will get the result of: (no of scores-1)*2 and the next will get 2 less than the top. So for 9 raw scores you get 16, 14, 12, etc . . . down to 4, 2, 0 as shown under the column headed SCORES (shared positions share both score values) Board Results SCORE Should be 1 500 16 4 1 -300 0 0 1 400 8 2 2 -200 3 1 2 450 14 4 2 -200 3 1 3 -50 6 0 3 430 11 3 3 430 11 ...

Golf Handicap
Being that I am (1) too cheap to fork out \$30 for software that doe this for you, and (2) interested in learning more about Excel, I hav been trying to create a spreadsheet that will calculate my gol handicap. The calculation for getting your handicap calls for usin the handicap differential of your 20 most recent rounds of golf, and o those 20, averaging the 10 lowest and then multiplying that average b 0.96. I've attached the spreadsheet that I have created and would b eternally grateful to anyone who can help. So far, this is what I have: =AVERAGE(N2:N35)*0.96 But I need to filter ...

Golf Stat
Looking for an excel spreadsheet that tracks golf stats. Thanks Rich in Maine Using Ron's google search addin http://www.rondebruin.nl/ asking for golf in the subject line, I get -- http://tinyurl.com/58qk8 Don Guillett SalesAid Software donaldb@281.com "Rich Reed" <rric31@maine.rr.com> wrote in message news:1bsSd.22614\$vK5.948@twister.nyroc.rr.com... > Looking for an excel spreadsheet that tracks golf stats. > > Thanks > > Rich in Maine > > ...

Football Scores
Hi, I have an xls with a list of football matches. In column A I will have the home scores and in column B, I will have teh away team's scores. I then have in column C my predicition for teh home team and in column D the away team score predcition. I want column E to compare teh two sets of scores and award me 3 points for an exact match of the scores and 1 point if I predict teh correct wwinner or a draw. - How can I do this? Thanks Simon -- Number_8 ------------------------------------------------------------------------ Number_8's Profile: http://www.excelforum.com/member.php...

formula to move a scored number to a score sheet
i run a race team. we have 20 teams competeing. we select 7 riders each to compete in various age and skill levels. we sort the riders by age and skill level. as we score the races, i need a formula that will send the results back to the team score card. for example i have 20 score card, one for each team. each card has 3colums with 7 cells. after we sort the riders they are no longer grouped by teams. the formula would have to know to send the score of a rider from team (a) to the correct score card and if the first cell has a score in it, to place it in the next cell in the column a...

formula for golf league
I need a formula that will automaticaly update handicaps using the last three scores entered. ex: A1 B1 C1 D1 E1 formula 35 32 38 -- Message posted from http://www.ExcelForum.com > using the last three > scores entered. > > ex: A1 B1 C1 D1 E1 formula > > 35 32 38 ?? <g> What are you playing Crazy Golf? To add up the last three scores in row 1 try: =SUM(OFFSET(A1,0,COUNT(1:1)-3):OFFSET(A1,0,COUNT(1:1))) Assumes that there ar...

Golf scores
I am trying to change the cell colour depending on the input against the actual Par . ie Column A = the actual par for each hole, Column B is the actual score if the input for cell B2 is greater than cell A1 the cell = Red """" """""" """" """ = to """ """ """" = Green """" """""" """""""" less """" ...

Golf Pool
Hello - I am trying to figure out a way to track a fantasy golf pool. I need to track every player's totals earnings and then create a report which shows every team (made up of anywhere from 5 to 10 players). I created a spreadsheet listing each player and their total earnings. I'm stuck at this point, since I don't know how to create each team in such a way that would allow me to then print a report, sorted in descending order, based on the teams total earnings and listing each player on the teams and their individual earnings. Is this possible using Excel? Any help w...

Formula for tracking Nassau golf bets
I'm trying to track a golfing Nassau bets between two teams. In columns B & C are the two teams respective scores on each hole. Column D tracks how Team 1 stands for Bet #1. If Team 1 has the highest score on hole 1, they are -1, if they are lowest on hole 1 they are +1, and if they tie, they are 0 (zero). Each hole then increments column D by one, up or down, or remains the same depending on the outcome of that hole. Once a team is up or down by 2 a new bet (Bet 2) starts and is tracked in column E. (Etc. to Bets 3, 4 and perhaps 5.) Bet two, once started should increment ju...

Formulae for a score chart
I'm making a score sheet with results and the total result, but was wondering how I can make the position appear under the total (e.g First, second etc), in other words the formula. I'm sure there's a way it's just been a long day Thanks Nick There is rank; for example +RANK(B1,A1:A25,1) will show you where the value in B1 stands among values in A1:A25. the final argument ",1" is optional, but in this case makes it so that the lowest number has the "best" ranking. "Nick H" <anonymous@discussions.microsoft.com> wrote in message news:0...

Golf score problem
I have just posted this in a golf newsgroup, but then it occurred to me I would probably have more chance going to the specialist group? I have just been co-opted as secretary to the Senior's section at my golf club, and I have been trying to set up an Excel programme to use for the yearly medal trophy. We play a medal once a month (12 times a year) and the best three rounds for each player are added together - the person with the lowest 3 scores winning the trophy. What I would like to do is set up a sum in Excel which will take the lowest three scores (for each person) and add them toget...

Golf scorecard again
Is there a formula for this? Stableford Golf Scores. To work out a players total points based on their handicap. Each hole is handicapped (Stroke Index 1-18). The players handicap indicates the hole upon which he can deduct a stroke, ie. Players handicap is -4, he deducts a stroke on each of the first four handicapped holes. If his handicap is -28, he deducts a stroke on each hole, 1-18 and an additional stroke on holes handicapped 1 thru 10. (His handicap minus 18). Players handicaps run from -0 to -28. Points are scored as follows: 1 over par= 1pt par= 2pt 1 under par= 3pt 2 under pa...