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

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

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

Conditional Formating: MAX & MIN
 

Hi Claus,
Thanks for your help.
It works great.
Wes