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