Highlight repeating number in column

  • Thread starter Thread starter NB
  • Start date Start date
N

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.
 
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
 
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

.
Click to expand...
 
Back
Top