You're welcome. Thanks for the feedback!

Biff

"Phil Lewis" wrote in message
...
Worked great. Thanks for the quick response.
--
Phil Lewis


"Biff" wrote:

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.