the only way i can figure out is two steps

1) in some row in the column (a in this case) put this array formula
(entered with control+shift+enter) - maybe in cell a2

=IF(COUNTIF(A3:A7,MIN(A3:A7))=1,1,2)

then, conditional format cell a1 as

=+A2-1=0

and if true choose format


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=383774