Thank you for looking at my question. I am attaching a small excerpt from a large charity golf tournament that last over 6 rounds. I am trying to use conditional formatting to highlight the lowest 4 rounds for each player. Also, there needs to be a minimum of 4 rounds, so if there are three rounds or less, there should be no highlighting. I have made a number of attempts, including the one on the attached. As you can see, 5 instead of 4 values are highlighted in several rows.
Thank you again for your help