MAX Conditional Formatting

P

Patrick_KC

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
 
T

Trevor Shuttleworth

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
 
R

Ray A

One way
Highlight range A1:A4
Format>conditional formating>formula is>=if(max(a1:a4)=a1,true,false)
<formating>
HTH
ray
 
M

Morrigan

Select A1 -> Conditional Formatting

Formula is =IF(MAX($A$1:$A$4)=$A1,1,0)

Copy A1 -> Paste Special to A2:A4 -> Formats
 
Top