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

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

2020-02-04 Conditional formatting for duplicate values in a field.yxmd