Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Unhappy 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
Attached Files
File Type: doc 23.doc (29.5 KB, 217 views)
  #2   Report Post  
Roger Govier
 
Posts: n/a
Default 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|
+-------------------------------------------------------------------+

  #3   Report Post  
Max
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Error ddate Excel Worksheet Functions 0 May 5th 05 09:00 PM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 07:13 PM
conditional formatting question Deb Excel Discussion (Misc queries) 0 March 23rd 05 03:07 AM
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 02:08 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 04:33 PM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"