I am trying to automate a bowling statistics table. Each bowler has multiple games, one column for each.
The problem I am having is that I am using =J1>=LARGE($J$3:$K$22, 4) in conditional formatting.
I want to have it conditional for each men and women category. Also it should only calculate from the highest game of each player.
What is happening as can be seen in the uploaded file is that it is counting both scores of one player if they had two top scores.

Any suggestions would be appreciated.

https://docs.google.com/spreadsheets...it?usp=sharing