duplicate values
 

Hi

I need to find and list (or change color of the row) all values which are
duplicated in Col B. How to do this?

s.

duplicate values
 

Hi,
try
=COUNTIF($B$1:$b$100,B1)1
as your conditional formatting formula.
Or put the formula into a separate column and format based on TRUE

I don't think so, this is what I asked for, but thank you for try. Maybe I
need a macro ...
For example:
Col B
f
g
h
k
g
h
m


I would like to change for red color every duplicated value in col B: g, h
should be RED

duplicate values
 

Hi, that is what my suggestion will highlight.
for the data sample you named:
Select the cells in column B, click Conditional formatting - Formula Is

Thank you, now works fine! (I think I miss understood the first post,
because I tried but it not worked out).

s.