Conditional formatting on =max()

[Seabootz]

I need to conditional format a cell to a colour for the maximum numbe
in a range but I keep getting the maximum number plus one or two othe
numbers not always the maximum. What am I doing wrong

Seaboot

+-------------------------------------------------------------------
|Filename: 23.doc
|Download: http://www.excelbanter.com/attachment.php?attachmentid=39
+-------------------------------------------------------------------

 

[Roger Govier]

Hi

What is the range you are applying CF to?
What is the formula you are using?

Regards

Roger Govier

 

[Max]

Assume the data is in B2:B10

Select B2:B10 (with B2 active),
then apply conditional formatting using the formula:
=B2=INDEX($B$2:$B$10,MATCH(MAX($B$2:$B$10),$B$2:$B$10,0))

A sample construct for the above is at:
http://cjoint.com/?lhpScaMqJm
Seabootz_newusers.xls