View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shawn Shawn is offline
external usenet poster
 
Posts: 271
Default Highlight highest numbers in a range.

I have a range say A1:A10. Each cell contains a number. I would like a code
that would search this range and autofill the cell of the highest number
green and the second hightest number blue??? Please and thank you.
--
Thanks
Shawn