Figuring Golf Skins & Highlighting that cell

[rwhite713]

Ref http://www.excelforum.com/excel-work...-for-golf.html

i too am having trouble with identifying skins. I do not want to run a report i want to insert formulas that highlight the skins on my worksheet. There are no carryovers - so if there is a tie there is no skin.

I've got very close, but seem to have trouble if the entire column is not in the formula. My worksheet is intended to be similiar to that of a golf score card, meaning that in a single row there will be a value of par, a gross score value, a net score value and points.

Can someone take a look at my workbook and see where my problem is? I've put some notes on sheet 5 where i think i've got close. i've also included the sheet that has my net score formula as well as my stableford formula

Thanks for your help. by the way, this is my first post as i just joined today.