duplicate values

  • Thread starter Thread starter soonic
  • Start date Start date
S

soonic

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.
 
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
Click to expand...

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
 
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
Click to expand...

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

s.
 
Back
Top