+ Reply to Thread
Results 1 to 7 of 7

Golf Scoring System_Automatically Highlighting Cells

  1. #1
    Registered User
    Join Date
    08-04-2020
    Location
    Manchester
    MS-Off Ver
    Excel for Mac 16.39
    Posts
    13

    Golf Scoring System_Automatically Highlighting Cells

    Hi all,

    I have very kindly received help with the attached file and got it working the way I want it to work (for now). However you will note that some of the cells are yellow and some are red. This has been done manually, but I am wondering if it can be done automatically?

    On the attached file, on the Calculations sheet, column E shows the number of counting rounds (the lowest x number of scores) from the scores sheet. Column F takes the lowest x rounds and adds them up. What I would like, is the lowest x rounds, which are added up in column F, to be highlighted yellow on the scores sheet...with the rest of the scores having no highlight.

    Is this possible?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    4,972

    Re: Golf Scoring System_Automatically Highlighting Cells

    Try the attached - you did not describe why cells were filled with red, so I just did the yellow, with the addition of a helper column of formulas in A. I also did not know if you wanted to highlight scores that were tied with others in the highest of the low scores, so I broke the ties and chose the newest of the scores if they were tied.
    Attached Files Attached Files
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    08-04-2020
    Location
    Manchester
    MS-Off Ver
    Excel for Mac 16.39
    Posts
    13

    Re: Golf Scoring System_Automatically Highlighting Cells

    Sorry for the delay in checking this...but perfect!! Thank you so much.

  4. #4
    Registered User
    Join Date
    08-04-2020
    Location
    Manchester
    MS-Off Ver
    Excel for Mac 16.39
    Posts
    13

    Re: Golf Scoring System_Automatically Highlighting Cells

    Sorry...very nearly perfect...but as you mentioned, I did not explain the red highlight...so the slight imperfection is my fault!

    The "counting rounds" are only from the last 20 rounds the player has played. So once 21 rounds have been played, the first round they played months ago, drops out of contention and is highlighted red, with only the last 20 being in contention for the best 10 rounds. Is this possible?

  5. #5
    Registered User
    Join Date
    08-04-2020
    Location
    Manchester
    MS-Off Ver
    Excel for Mac 16.39
    Posts
    13

    Re: Golf Scoring System_Automatically Highlighting Cells

    Also...where scores are the same...the latest score should be highlighted yellow as opposed to a later one...although I guess that will not make a difference to the maths.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,082

    Re: Golf Scoring System_Automatically Highlighting Cells

    In response to post #4, perhaps the following will help.
    1. Column A is populated using: =IF(COUNT(D8:ED8)<20,0,AGGREGATE(15,6,(COLUMN(D8:ED8)-COLUMN(C8))/(D8:ED8<>""),COUNT(D8:ED8)-20)+3)
    2. The conditional formatting rule for red fill is: =AND(COLUMN()>=4,COLUMN()<=$A8)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  7. #7
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    4,972

    Re: Golf Scoring System_Automatically Highlighting Cells

    Try this version - needed another helper column of formulas....
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Golf Handicap / Scoring System
    By Golf_Tragic in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 08-13-2020, 08:02 AM
  2. New Member - Interested in Golf Scoring Systems
    By TJTwitty in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-10-2019, 06:15 PM
  3. Golf scoring formula request
    By flyerpicker in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 06-10-2017, 04:22 PM
  4. Replies: 8
    Last Post: 08-29-2012, 06:56 AM
  5. Excel 2007 : Disc golf scoring and ranking
    By trichard311 in forum Excel General
    Replies: 0
    Last Post: 02-07-2012, 05:43 PM
  6. golf tournament scoring question
    By pwedge in forum Excel General
    Replies: 4
    Last Post: 08-20-2007, 05:29 AM
  7. Golf Scoring with a Challenge - UDF
    By Kieranz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2006, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1