Conditional Formating Absolute Minimums

  • Thread starter Thread starter tbieri
  • Start date Start date
T

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
 
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
 
Back
Top