I am using conditional formatting to find the min. value in each row.
It ignore the 0 when the clicking on the conditional formatting but when i run it using macro, it take the 0 as the lowest value
Any one can help?
My formula is
=A2=MIN(IF($A2:$C2<>0,$A2:$C2))
All column are formatted to number value.
Capture.PNG
Bookmarks