MAX Conditional Formatting
 

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

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

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

One way
Highlight range A1:A4
Formatconditional formatingformula is=if(max(a1:a4)=a1,true,false)
<formating
HTH
ray

"Patrick_KC" wrote:

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

Select A1 - Conditional Formatting

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

Copy A1 - Paste Special to A2:A4 - Formats



Patrick_KC Wrote:
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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390349