Conditional Formatting for Four Lowest Values

  • 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

  • Hello,


    Your formula is correct :)


    What you do need is to break ties ... which means you will probably need to add a helper worksheet ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Glad to hear this could help you out :)


    Thanks a lot for the feedback, for your Thanks ... AND for the Like :thumbup:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)