Highlight repeating number in column

[NB]

I have a column with data in it and I need to find a way
to automatically highlight/change color of any number that
is found more than once.

For example, if I have the following numbers:

NB-23
NB-45
NB-56
NB-97
NB-45
NB-87
NB-56

I would need the 2nd NB-45 and the 2nd NB-56 to be colored
red.

I would appreciate any assistance that anyone can provide.

Thank you & Best regards.

 

[Dan E]

NB,

For example if your data were in A1:A7

- Select cells A1:A7
- from the menu choose Format -> Conditional Formatting
- In the condition 1 dropdown choose Formula Is
- In the condition field enter:
=COUNTIF(A$1:A1,A1)>1
- Set your format (ie cell highlighting, font colour, etc.)
- Hit OK

Dan E

 

[NB]

Thank you so much Dan...I appreciate it.

-----Original Message-----
NB,

For example if your data were in A1:A7

- Select cells A1:A7
- from the menu choose Format -> Conditional Formatting
- In the condition 1 dropdown choose Formula Is
- In the condition field enter:
=COUNTIF(A$1:A1,A1)>1
- Set your format (ie cell highlighting, font colour, etc.)
- Hit OK

Dan E

.