Solved Golf Skins score sheet

February 16, 2013 at 17:55:56
Specs: Windows 7
I need to find the highest value in a column and highlight that cell, whilst at the same time check if there is more than one cell with that same highest value. If there is then return either 'H' or 'Halved' in a cell at the top of that column.

See More: Golf Skins score sheet

Report •

February 16, 2013 at 20:42:00

Apply the Top/Bottom conditional format rule to each column set to the top "1"

Report •

February 17, 2013 at 02:59:41
✔ Best Answer
Use this Conditional Formatting rule to highlight the highest value(s) in the range A2:A20


Use this formula in A1 to return Halved if the MAX value appears more than once:


Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question