keep the cell the same unless it exceeds a predetermined number then change cell

I hope this makes sense. This is a golf thing, Equitable Stroke Control. If your handicap is within a range, the current score can't exceed a certain amount. The scores need to be adjusted after the scores are entered before Gross total. I can't figure this out. I'm trying to use a case select but something isn't quite right.
The highlighted green scores on the scores sheet are in question and need to be adjusted. I have a loop that would adjust and color according to the category. The CHcp changes several times a month.
If your CHcp is:
=<9 then max score is Par+2
10-19 max 7
20-29 max 8
30-39 max 9
40+ max 10
Also, can you check my loop to see if there is a more efficient method for coding?
Any assistance will be appreciated and thank you in advance for reviewing.
Thanks
Spyderwoman

This is to adjust each hole score according to the hcp, if needed and mark birdies.

Please Login or Register  to view this content.

I don't know golf. From my understanding you basically whack a little white ball and it goes flying into the water, then you gotta go get it.

However, I thought that you calculated the handicap at the end of the game. Not for each hole, and this code seems to alter the initial values. This doesn't seem right to me, but I don't know golf.

Also, on the surface of your question I'm wondering why you can't just use a basic condition - i.e if score < maxscore then TotalScore=score else TotalScore=MaxScore? this would alter only the final score.

If you do want to change the individual holes you probably do need the select case, but you still need to use the condition.

Personally, I would never alter the start values - put them on a different sheet and run your code to create new values base on the update.

wow, how do you do this so fast. I'll check it out and let you know.
thanks Jindon

MarvinP, you're formula and layout is perfect. I couldn't figure some of Jindon out, but will use parts of it to format the birdies. Thanks to both of you. I'll mark this as solved and give you a A+ rating once I find it.
thanks again

Marvin,
Thanks for your help. I'm not sure if this was included in the workbook I uploaded but I use the vba loop for birdies so it will mark the player's name. I then filter by name so that I know who has a birdie without scanning the entire sheet, kind of like a report. I never have been good at the conditional formatting like your example, that is the main reason why I wrote it in a vba loop. Thanks again for your help and input. If you have other ideas, please feel free to pass along. Women's leagues are a pain in the ????.