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!

1234	2	feb 6th
1	3	feb 4th
1234	2	feb 6th
4324	5	feb 8th

<tbody>
</tbody>

 

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