Hi!

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

You can shorten this formula a little:

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

The "=TRUE" is redundant.

To apply cf to the column header:

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

Biff

"dlvgolf" wrote in
message ...

Now I'm probably pushing the envelope, but can this be added...
I've got a header at the top of each column of numbers. Once the
conditional formatting finds a cell to highlight... can the header cell
of that column also be highlighted? This keeps me from having to scan
over all the columns looking for the highlighted cells... I can just
scan across the header row, spot the highlighted header cell and then
scroll down to find the unique number.

Thanks again for your help.


--
dlvgolf
------------------------------------------------------------------------
dlvgolf's Profile:
http://www.excelforum.com/member.php...fo&userid=6628
View this thread: http://www.excelforum.com/showthread...hreadid=383774