Trying to setup spreadsheet to do gross and net skins for golf

sharger25

New Member
Joined
Dec 13, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
would like the net skin to highlight the net skin also.

HoleAdj.123456789Score101112131415161718ScoreTotal
HandicapHDCPHdcp313179157111512101646182148
Par5434345443645345344436
1​
Jason Miconi654352554437643674443417872
2​
Rob McConnel1074453545542643452756428474
3​
James Kanizaj666343463439563563655448377
4​
Robert Kanizaj16654645774484543106456479579
5​
Coryn Princevalle261073547976586558635765110983
6​
Jeff Stefanski17865469675564554648564710386
7​
Joshua Mau-654452466541544444454387985
8​
Aaron Outama16610473658453553562764439680
9​
Marty Witkowski7543536656437535103655499285
10​
Mike Witkowski274344456542453352444347674
11​
Buckster269866266855655451037575110781
12​
Jbuck2466442597649573774566509975
13​
Dave MacDonald765563465444643365646438780
14​
Todd McKenzie16555635107551762663544439478
15​
Kyle Staplins35744737877546745638765210671
16​
Marius Williams18955665897606765647645111193
17​
Tim Pitkin23954639595557445755454610178
18​
Pat Taylor843552366539664453864468577
19​
SH354463455541454564446428380
gross
net
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
would like the net skin to highlight the net skin also.

HoleAdj.123456789Score101112131415161718ScoreTotal
HandicapHDCPHdcp313179157111512101646182148
Par5434345443645345344436
1​
Jason Miconi654352554437643674443417872
2​
Rob McConnel1074453545542643452756428474
3​
James Kanizaj666343463439563563655448377
4​
Robert Kanizaj16654645774484543106456479579
5​
Coryn Princevalle261073547976586558635765110983
6​
Jeff Stefanski17865469675564554648564710386
7​
Joshua Mau-654452466541544444454387985
8​
Aaron Outama16610473658453553562764439680
9​
Marty Witkowski7543536656437535103655499285
10​
Mike Witkowski274344456542453352444347674
11​
Buckster269866266855655451037575110781
12​
Jbuck2466442597649573774566509975
13​
Dave MacDonald765563465444643365646438780
14​
Todd McKenzie16555635107551762663544439478
15​
Kyle Staplins35744737877546745638765210671
16​
Marius Williams18955665897606765647645111193
17​
Tim Pitkin23954639595557445755454610178
18​
Pat Taylor843552366539664453864468577
19​
SH354463455541454564446428380
gross
net
Need formula to have skins to show at bottom for gross and net
 
Upvote 0

Forum statistics

Threads
1,214,818
Messages
6,121,725
Members
449,049
Latest member
MiguekHeka

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