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?

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

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?

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.