Hi!

Assume the range in question is A1:A10.

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

Biff

"Phil Lewis" <Phil wrote in message
...
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.