View Single Post
  #2   Report Post  
Trevor Shuttleworth
 
Posts: n/a
Default

Patrick

select cells A1 to A4. Then input the following Conditional Formatting
condition:

Formula is: =A1=MAX($A$1:$A$4) exactly as typed (2x = etc)

Pick the highligh you want and press enter

Regards

Trevor


"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