Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating: MAX & MIN
Hello and thanks for reading,
I use two conditional format formulas in the same column to bold the highest and lowest values starting in row 6 to row 38 as follows: =(B6=MAX($B$6:$B$38))*(LEN(B6)0) =(B6=MIN($B$6:$B$38))*(LEN(B6)0) It works fine. However, I'd like to alter this to only bold the highest value if that value is 2 (greater than +2) and only bold the lowest value if that value is <-2 (less than -2). Help would be appreciated as my attempts at messing with the formulas fail. Thanks, Wes |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating: MAX & MIN
Hi Wes,
Am Sat, 13 Apr 2013 20:55:10 -0700 (PDT) schrieb Wes Finch: =(B6=MAX($B$6:$B$38))*(LEN(B6)0) =(B6=MIN($B$6:$B$38))*(LEN(B6)0) try: =(B6=MAX($B$6:$B$38,2)) and =(B6=MIN($B$6:$B$38,-2))*(LEN(B6)0) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating: MAX & MIN
Hi Wes,
Am Sun, 14 Apr 2013 07:41:53 +0200 schrieb Claus Busch: =(B6=MIN($B$6:$B$38,-2))*(LEN(B6)0) so zero can't be minimum you can change the formula: =(B6=MIN($B$6:$B$38,-2)) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating: MAX & MIN
Hi Claus,
Thanks for your help. It works great. Wes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating | Excel Discussion (Misc queries) | |||
Formating - Conditional | Excel Programming | |||
conditional formating?? | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Programming |