W
Wes Finch
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
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