Adjust Golf league Skins Conditional formatting

Gulfcourse

New Member
Joined
Nov 5, 2023
Messages
32
Office Version
  1. 365
Platform
  1. Windows
Hello,
I have a sheet, within a file, I'm using to find skins, the lowest individual score on each golf hole, if there is one.
I'm using conditional formatting and the formula:
=AND(C4=MINIFS(C$4:C$36,C$4:C$36,">0"),COUNTIFS(C$4:C$36,C4)=1,-C$1)
to highlight the cell if there is a skin on each hole throught for all 18 holes.

The person in ROW 17 has decided not to participate in the skins game.
I no longer wish to include his scores for skins but cannot simply cut the row since all the sheets list the golfers in alphabetical order, and I also use the sheet for points.
Another reason I don't want to cut the row, I need to keep it alphabetical.

This may happen for a few more people, perhaps row 24, so I may as well ask now how to do it since I've come up empty.

Is there a way to edit the formula to ignore certain rows?

Thank you
 

Attachments

  • Skin_Sheet.jpg
    Skin_Sheet.jpg
    219.2 KB · Views: 36
Thank you Fluff, yours worked, JGordon11, yours did not but thank you for the reply, much appreciated
 
Upvote 0

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Glad we could help & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,223,885
Messages
6,175,187
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top