I used the formula =AND(A1=MIN(A:A),COUNTIF(A:A,A1)=1)in conditional formatting to find and highlight the single lowest number in a column. This worked fine in my test sheet. When I used it in another workbook it did nothing in one column and would only highlight ones or zeroes in the others.
"WHAT HAPPENED?"
"WHAT HAPPENED?"