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. Follow

2 Replies
459 Views

Similar Articles

[PageSpeed] 10

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
Reply:

Similar Artilces:

grade score
how to change grade (A,B,C) to 4,3,2 score You could use the Edit > Replace feature three times to find A and replace with 4, and find B and replace with 3, etc.............or you could use a helper column and put in a formula like =IF(A1="A",4,IF(A1="B",3,IF(A1="C",2,""))) and copy it down the helper column. Vaya con Dios, Chuck, CABGx3 "Apiwat" <Apiwat@discussions.microsoft.com> wrote in message news:7FA560EC-0F3E-4FC1-A6D5-F1B1C6F0408E@microsoft.com... > how to change grade (A,B,C) to 4,3,2 score With the grade in A1 =...

Assigning checkbox weight (score) in a form
Hello - I need to assign a weight (score value) to a checkbox field. The weights assigned to each checkbox will change, so the boss needs have the ability to manage the checkbox weights in an administrative form. Then, the calculation between the checkbox field and the weight is presented in a report. In addition, the report has to take into account the different weights assigned to each field over time. For example, over a period of 2 months, the checkbox weight could have a value of 1, 2, and 3 points. What is the best way to handle this? Thanks!!! Steve -- Message posted via AccessMons...

Score Rating
All, I would appreciate if you could helpme with the following: I am trying to determine the score level in one cell for the belo creteria: score rate >80 or <90 "need improvement" >90 or <95 "good" >95 or =100 "excellent" I will have two cells where in one I will input the score and the second one determines the rate of the score. Thanks. =IF(A1>95,"excellent",IF(A1>90,"good","needs improvement")) -- Gary''s Student - gsnu200764 Thanks! It worked! "Gary...

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 ...

Can I create a golf handicap calculator
Has any one already created one and can I get a copy of it Doug, I've never seen, or heard, of an existing template for golf handicapping. You might try your local amateur golf association. In Northern California that would be the NCGA. If you find one, please post back. I'd very much like to see it. -- Sincerely, Michael Colvin "Doug B" wrote: > Has any one already created one and can I get a copy of it ...

Golf Tee sheet.
Hi guys, Im trying to create a golf tee sheet with some usefull functions. Im having trouble working out how to do a couple of things though. Firstly I would like to change a cell colour when a checkbox is clicked (The checkbox will be clicked when the tee time has been paid for) - that will then turn another 3 cells Green. The other thing I know im going to have trouble with is... I have 2 coloumns (one is for 9 hole rounds the other is for 18 hole) basicly if anything is typed into the 18hole cell for that time slot I would like the time slot exactly 2 hours ahead to be booked with the...

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...

Multiple Credit Scores
I registered and set up the "My Credit Scores" and "My Credit Alerts" for myself and was wondering how to set it up for my spouse? I started to set up another account but was afraid it would remove mine. Any ideas? Thanks, Ryan ...

drop one score, average the rest
How can I drop the lowest score of a group of scores (from tests), then get the average for the rest? One way =SUMPRODUCT((SMALL($A$1:$A$50,ROW(INDIRECT("2:"&COUNT($A$1:$A$50))))))/(COUN T($A$1:$A$50)-1) -- Regards, Peo Sjoblom "John" <anonymous@discussions.microsoft.com> wrote in message news:6645DFB1-7A58-435B-BA10-60765DED9526@microsoft.com... > How can I drop the lowest score of a group of scores (from tests), then get the average for the rest? =SUMPRODUCT((SMALL($A$1:$A$50,ROW(INDIRECT("2:"&COUNT($A$1:$A$50))))))/(COUN T($A$1:$A$...

Formatting for a score.
I'm having trouble putting in a score result into a single cell. Fo example, 2 - 1. I don't wanna span it over a few cells, but whenever put "2 - 1" into the cell it comes up as either "37988" or "2-Jan". tried formatting the cell as a normal number, and as general, but i reverts back to date or some other whacky format. Anyone got a wa around this? Oh, and I DO want to have spaces before and after the "- cos I hate the way "2-1" looks. Too cramped. Plus that doesn't wor either anyways -- Message posted from http://www.ExcelForum.com ...

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 """" ...

Awards for winners of sporting events eg golf
I'm looking for a template for certificates/awards to winners of sporting events - in this case golf. I'd like to award certificates for winners - mens and ladies, runners-up, nearest the Pin etc. Maybe something to your liking here: http://office.microsoft.com/en-us/templates/CT101043001033.aspx -- Don - Publisher 2000� Vancouver, USA "DougQ" <DougQ@discussions.microsoft.com> wrote in message news:13C3F2E2-9B72-43A8-BE83-EFBBDB574659@microsoft.com... > I'm looking for a template for certificates/awards to winners of sporting > events - in this case...

Golf scoring and calculation
I've put together a golf scorecard and recording system in Excel. I automatically calculates all relevant scores (total gross, nett stableford, holes won etc) and saves up to 65,000 rounds. Importantl (I think) it works for _all_ courses by simple adjustment of the pa and stroke index. It's free to anyone who wants it. I'd appreciate an feedback on it's usefulness etc. Go to www.junipergreen.net to have look and download. Nine Iron : -- juniper62 ----------------------------------------------------------------------- juniper622's Profile: http://www.excelforum.com/membe...

Free Credit Report and Free Credit Score
Free Credit Report and Free Credit Score View your Free Credit Report and Free Credit Score Online Instantly. http://creditreport.mzs-inc.com ...

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 > > ...

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...

Golf scoring and calculation #3
I can see that your version could be useful for analysing one's gam over a period of time. I put mine together to deal with groups having competition, outing etc or just for recording my seasons scores -- juniper62 ----------------------------------------------------------------------- juniper622's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1613 View this thread: http://www.excelforum.com/showthread.php?threadid=27570 ...

golf spreadsheet
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...

golf league spread sheet
I am trying to set up a spread sheet for my golf league. Here's an example: Member ___ Today's Score __ Net __ Current Handicap John Smith _____75 ________ 70___________5 Bill Smith _____76_________71___________5 Tom Smith _____ 77_________72___________5 John Parks _____72_________66___________8 Bill Parks _____78 ________69 __________ 9 Tom Parks _____80 ________ 73__________ 7 ...... and so on for 180 golfers Now I figured out how to list lowest net scores for todays round int an "A" Flight "B" Flight and a "...

formulate tests scores then average them as percentiles in excel
I need help So do we with a question lacking in detail as that is. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "David Pruden" <David Pruden@discussions.microsoft.com> wrote in message news:848AD2F1-14CC-419A-ABB5-23D7A0E5D127@microsoft.com... > I need help ...

Find High Score
Hi I am working on a Horse Shoe program -- I need to find the high score weekly of all games played D E F G H I J K L M N O Team #1 16-May 23-May 6-Jun 13-Jun 20-Jun 27-Jun 11-Jul 18-Jul 25-Jul 1-Aug 8-Aug 15-Aug 23 Total Points Gm.#1 30 51 55 0 0 0 0 0 0 0 0 0 24 Total Points Gm.#2 25 37 37 0 0 0 0 0 0 0 0 0 25 ...

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 ...

Ranking Scores in a Query
I have a query that uses 3 tables and 3 Xtab queries to use as record source for a report. Three of the numeric fields created as output from this query are: Fee Key Score 876 10 236.8 876 10 287.0 876 10 123.7 876 13 231.9 876 13 321.5 I need to add a ‘Rank’ field to produce: Fee Key Score Rank 876 10 236.8 2 876 10 287.0 1 876 10 123.7 3 876 13 231.9 2 876 13 321.5 1 The final result will be that the highest score, within Key, within Fee is First and so forth. Is this possible to do with a query. I have other ranking routines where the values being ranked are in a table but I woul...

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...

Need help on scoring
Hi I have a table like this: A B C D Albert Charles Mary Nancy ->names 5 2 1 4 ->values 3 9 4 8 ->values ------------------------------------------- 8 11 5 12 ->totals I want to know who has the higher total. This is easy on this example, because there are only 4 persons... but my real table has over 50. How can I quickly list the best score and who reached it. I need to rank that no.1 sa...