View Single Post
  #4   Report Post  
bill k
 
Posts: n/a
Default


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