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