Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |