Share via

conditional format lowest unique value in a column.

Anonymous
2018-03-30T00:55:09+00:00

Looking for the lowest unique value. Column 1 lists 44 different numbers. Looking to conditional format the lowest number, but only if it is unique. If there is a duplicate, nothing needs to be highlighted. This is to be used for a skins game tournament, where only the lowest unique score per hole will get a prize.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2018-03-30T09:03:19+00:00

    Let's say the list is in A2:A45.

    Select this range.

    On the Home tab of the ribbon, select Conditional Formatting > New Rule...

    Select 'Use a formula to determine which cells to format'.

    Enter the formula

    =AND($A2=MIN($A$2:$A$45),COUNTIF($A$2:$A$45,$A2)=1)

    Click Format...

    Specify the desired formatting.

    Click OK, then click OK again.

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments