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 "Smiley" icon, below, in the bottom right corner :)

  • Once you have tested the formula ... feel free to share your comments

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, 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 "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!