Conditional format non zero unique

[Legacy 141747]

I have a multi-column 4 row table with zero or positive values. In each column I want to highlight the lowest non zero value if it is unique - not quite the same as the lowest unique value, which may not be the lowest value!

So must be a Conditional Format formula

I am relatively new to Excel using Office for Mac 2004

 

[barry houdini]

If you have data in A1:D10 then select that range and use this formula in conditional formatting

=(A1=MIN(IF(A$1:A$10<>0,A$1:A$10)))*(COUNTIF(A$1:A$10,A1)=1)

 

[Legacy 141747]

Thanks, just what I asked for.

I'll try and learn from it!