finding duplicate entries

[Jack]

I have a list of zip codes (thousands of them) in a
column, is there a command that will find duplicate
numbers and turn them red?

thanks

 

[...Patrick]

In french:
in conditionnal format:
=nb.si($A$2:$A$1000;A2)
in xl english nb.si=countif replace ";" by "," and chose a color
conditionnal )

....Patrick

 

[Andoni]

go to format/conditional formatting.

chose formula a put this:
'I am supposing your looked column is A:A
=Countif(($A:$A);A1)>1
then put a red format and "DONE

 

[...Patrick]

=countif($A$2:$A$1000,A2) >1 !!!! sorry

In french:
in conditionnal format:
=nb.si($A$2:$A$1000;A2)
in xl english nb.si=countif replace ";" by "," and chose a color
conditionnal )

...Patrick