Conditional formatting for lowest number in a string

P

Phil Lewis

I have a column of numbers and want to color highlight the lowest number in
the column. However, I only want to color highlight if there is a clear
"winner". Ties should not activate the color. There is a posted article on
the MS site (article 909845) using an IF statment but it does not allow for
ties. Does anyone know how to do this.
 
B

Biff

Hi!

Assume the range in question is A1:A10.

=AND(A1=MIN(A$1:A$10),COUNTIF(A$1:A$10,A1)=1)

Biff
 
S

Sloth

you can also use "Cell Value is" - "Less Than" - and the following formula

=SMALL($A$1:$A$10,2)
 
Top