View Single Post
  #3   Report Post  
Anne Troy
 
Posts: n/a
Default

Try using CF with a formula =MAX($A$1:$A$4)
http://www.officearticles.com/excel/...ft_ excel.htm

*******************
~Anne Troy

www.OfficeArticles.com


"Patrick_KC" wrote in message
...
I'm hoping this is an easy one, but I just can't figure it out. I have a

4
numbers in 4 cells A1:A4. I want to highlight the highest number from

that
array using conditional formatting.

Any help is appreciated.
Patrick