# Golf Scoring System_Automatically Highlighting Cells

1. ## 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?

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

3. ## Re: Golf Scoring System_Automatically Highlighting Cells

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

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

7. ## Re: Golf Scoring System_Automatically Highlighting Cells

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

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

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