In thinking about it, I guess we could save 8 characters...

=AND(A1=MIN(A$1:A$6),MIN(A$1:A$6)<SMALL(A$1:A$6,2 ))

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
You could use this formula in a Conditional Format...

=AND(A1=SMALL(A$1:A$6,1),SMALL(A$1:A$6,1)<SMALL(A $1:A$6,2))

Rick


"JJ2356" wrote in message
...
I want to highlight the lowest number in a range, only if that number does
not equal another number in the same range.

For instance, if in Cells A1:A6, the number 2 is the lowest number and
all
other numbers are higher, I want the cell with the number 2 highlighted.

If in Cells A1:A6, the number 2 is the lowest number, but occurs twice, I
do
not want any cells highlighted.

Any advice?