How to use Conditional Formatting for duplicate values in a Column

I have a simple Smartsheet for re-ordering. The user scans the UPC of the item they need reordered. I'd like to setup a conditional format to highlight a cell if the UPC that is being added is already in the sheet. I can do this in Excel, having a hard time figuring it out in Smartsheet.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!