Highlighting duplicate values in a column

jeanniesry_4

Hello,

I created a helper column with this formula =COUNTIFS([Supplier Lot #:]:[Supplier Lot #:], [Supplier Lot #:]@row) so I can set a conditional format to highlight duplicate values in this lot supplier lot column. However, I noticed that duplicate values are not highlighted if the values have zeros in front of them. Can someone help me with a work around?

Thanks.

Amanda Carta

I saw this earlier. Maybe it will help?

https://community.smartsheet.com/discussion/74630/is-it-possible-to-flag-duplicates-when-the-data-starts-with-a-0-zero