Use the: Use a formula to determine which cells to format option.

Use a formula similar to this (this is for the range A1:A5):

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


--
Biff
Microsoft Excel MVP


"Steve Haack" wrote in message
...
I have a table of numbers and I want to put a conditional formatting rule
on
each column to highlight the lowest number in the column (there is a built
in
rule for this and it works fine), but ONLY if it is unique (this is the
part
that I cannot figure out how to do).

Anyone know how to do that?

Steve