Conditional Formating Absolute Minimums

[tbieri]

Howdy,

I am trying to CF each row of a table that contains several
columns. I want to highlight the number that is closest to
zero. I have the following formula: =B2=MIN(ABS($B2:$D2))
and it partially works. If the minimum number is greater
than zero the formatting happens, if the minimum number is
less than zero, or negative, then no formatting happens. I
have also tried =b2=min(abs($b2),abs($c2),abs($d2)) with
the same result. Any suggestions?

Regards

 

[Jason Morin]

Try:

=ABS(B2)=MIN(IF($B2:$D2<>0,ABS($B2:$D2)))

HTH
Jason
Atlanta, GA

 

[tbieri]

Thanks Jason

I used =ABS(B2)=MIN(ABS($B2:$D2)) and it works. It is
highly unlikely that there would be zero. Now that it
works, I am not sure why. Can you explain why the ABS is
needed in the first part?

Regards