highlight the range and under conditional formatting select
<cell value<is equal to
and enter in the right hand block =Max($A$2:$A$51)
then set the format.....
similar for the minimum
--
bill k
------------------------------------------------------------------------
bill k's Profile:
http://www.excelforum.com/member.php...nfo&userid=821
View this thread:
http://www.excelforum.com/showthread...hreadid=468415