Conditional formatting on =max()

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

Seabootz


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

--
Seabootz

Hi

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

Regards

Roger Govier


Seabootz wrote:
> I need to conditional format a cell to a colour for the maximum number
> in a range but I keep getting the maximum number plus one or two other
> numbers not always the maximum. What am I doing wrong
>
> Seabootz
>
>
> +-------------------------------------------------------------------+
> |Filename: 23.doc |
> |Download: http://www.excelbanter.com/attachment.php?attachmentid=39|
> +-------------------------------------------------------------------+
>

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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Seabootz" <[email protected]> wrote in message
news:[email protected]...
>
> I need to conditional format a cell to a colour for the maximum number
> in a range but I keep getting the maximum number plus one or two other
> numbers not always the maximum. What am I doing wrong
>
> Seabootz
>
>
> +-------------------------------------------------------------------+
> |Filename: 23.doc |
> |Download: http://www.excelbanter.com/attachment.php?attachmentid=39|
> +-------------------------------------------------------------------+
>
> --
> Seabootz