duplicate values

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

 

[teylyn]

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

teylyn

 

[soonic]

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

 

[teylyn]

Hi, that is what my suggestion will highlight.

for the data sample you named:

Select the cells in column B, click Conditional formatting - Formula I
-

=COUNTIF($B$1:$b$100,B1)>1

define the format to be red and hit OK

Now all g and h values in column B will be red.

What makes you not think so? Have you actually tried it?

regards, teylyn
'The Code Cage - Microsoft Office Help - Microsoft Office Discussion
(http://www.thecodecage.com)

 

[soonic]

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.