Conditional formatting for duplicate values in a field

[James1]

Hi,

Is there a straight forward way to highlight duplicate values in a field - without having to use unique tools? All I want to do is highlight a cell if it is repeated in a field. For example all cells that are 'A' are highlighted blue. The same way duplicate values are can be highlighted using conditional formatting in Excel.

Thanks,

[fmvizcaino · Accepted solution]

Hi @James1 ,

Attached is an example showing how to do it. I'm using the recordID and the sort tool to return to its original order after counting.

Let me know if that makes sense to your problem.

Best,

Fernando Vizcaino

[JosephSerpis]

Hi @James1 I mocked up a workflow that flags all duplicates without using the unique tool. 

Let me know what you think?