I'm trying to figure out a way to enter hole by hole scores and then have excel highlight the skin (low score) on the hole if there is one. I'm attaching what I would like the sheet to look like.
I've been trying to use conditional formatting for the first time and i'm really having a tough time with it. Thanks.
Hi pjfan, welcome to the forum.
I have a skins spreadsheet somewhere around here.. let me find it and upload it for you, maybe it will help.
Maybe like the attachment? (The additional holes are for playoff.)
Entia non sunt multiplicanda sine necessitate
That is what i'm looking. A couple of other things i'm looking for. During a tournament, i may have up to 150 golfers playing, what will i need to do to add them in all on one sheet. Also, I don't need to no about carryovers, since they don't come into play during tournaments. Thanks for your help. This site is great.
Delete the unneeded extra holes, copy what's there down as many times as necessary, and adjust the references. You can hide the calculation rows.
I am trying to figure out how you are highlighting the skin won with the green in the top section? I doubled the number of players and now row eight(6th player, the whole row is highlighted but everything else is correct.
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks