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

Conditional formatting on =max()
 

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|
+-------------------------------------------------------------------+

Conditional formatting on =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
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Seabootz" wrote in message
...

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