highlight duplicates

[don matteo]

Hey everyone so here is what im trying to figure out.
i have 100s of rows of data that i need to filter out if specific cells match each other so for example
if A, B and C are the same as another other row with A, B and C i want them to highlight
I tired some google searches and i just cant figure it out
so in the table below id want it to highlight the 1st and 3rd row

thank you!


[TABLE="width: 500"]
<tbody>[TR]
[TD]1234[/TD]
[TD]2[/TD]
[TD]feb 6th[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]3[/TD]
[TD]feb 4th[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]2[/TD]
[TD]feb 6th[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4324[/TD]
[TD]5[/TD]
[TD]feb 8th [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcelo Branco]

Say your data are in A2:C5

Select A2:C5
In Conditional Formatting pick the Formula option and insert this formula
=COUNTIFS($A:$A,$A2,$B:$B,$B2,$C:$C,$C2)>1
pick the format you want

M.

 

[don matteo]

i did that and its not highlighting the duplicates

 

[Marcelo Branco]

It worked for me. We need the exact location of your data.

M.

 

[don matteo]

they are in column B,E and F
so if row 1, B, E and F match row 22 and 23 and 28(for example) B, E and F. I would like those to highlight

 

[Marcelo Branco]

Say your data are in rows 1 to 100, that is B1:F100

Select B1:F100
In CF pick the Formula option (the last one) and insert this formula
=COUNTIFS($B:$B,$B1,$E:$E,$E1,$F:$F,$F1)>1

Format button and pick the format you want (for example: Fill --> yellow)
Ok, Ok

M.

 

[don matteo]

it worked!
you are a champ
thank you!