• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

Excel: highlight lowest number in column if it's unique

Complicated but simple... Is it possible to write a formula that would highlight the lowest number in a column, but only if the number is unique?  It's for a golf skins scorecard.  It basically highlights the winner of each skin, if there is no tie.
0
Cerixus
Asked:
Cerixus
  • 4
  • 3
  • 2
1 Solution
 
cb1393Commented:
Version of Excel?
0
 
CerixusAuthor Commented:
2007, sorry

If not possible, the user MAY have access to 2010
0
 
cb1393Commented:
No problem... see attached. There's no formulas, just 2 highlight rules. The first checks for duplicates and, if found, prevents processing of the next formatting step which hilights the bottom 1 value in the list.
score-list.xlsx
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
CerixusAuthor Commented:
Stupid question... I opened the file, how do I "view" the highlight rules?
0
 
CerixusAuthor Commented:
Nevermind, found it.  Thanks.
0
 
ISO30Commented:
No problem:

1) Click on a cell anywhere within the table
2) On the Home tab at the top, click the Conditional Fomatting button

You should see the two rules defined there.
0
 
cb1393Commented:
btw... ISO30 is me- please accept response from ISO30 as the solution (if it is indeed the solution you are looking for) as I am in the process of changing accounts.
0
 
CerixusAuthor Commented:
So if they had 18 columns (for each hole) would they have to apply the conditional formatting individually to each column range?
0
 
ISO30Commented:
Actually, no. If you copy/paste the column containing the values/formatting into the adjacent column, it should carry over the conditional formatting also and apply it only to that column.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now