Cond format using MIN

[Guest]

Hi al

Frank kindly gave me this formula to use in my cond formatting of rows

=A1=MIN($A1:$J1

This works great, however if there isn't any data in the row I would like it to omit the format

Something like: If( A1:J1=0,"",=A1=MIN($a1:$j1

any ideas

Gero

 

[firefytr]

maybe something like this...

=(A1=MIN($A1:$J1))*($A1:$J1<>"")

{untested

 

[Peo Sjoblom]

Try

=AND(COUNT($A$1:$J$1)>0,A1=MIN($A1:$J1))

 

[Guest]

Pe

Thank

Perfect

Geron