A tweak to snb's conditional format to:
will handle zeroes.=OR(B3=MIN(IF(B$3:B$20>0,B$3:B$20,9E+99)),B2=MIN(IF(B$3:B$20>0,B$3:B$20,9E+99)),B1=MIN(IF(B$3:B$20>0,B$3:B$20,9E+99)))
A tweak to snb's conditional format to:
will handle zeroes.=OR(B3=MIN(IF(B$3:B$20>0,B$3:B$20,9E+99)),B2=MIN(IF(B$3:B$20>0,B$3:B$20,9E+99)),B1=MIN(IF(B$3:B$20>0,B$3:B$20,9E+99)))
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote