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