How to high;ight exact match ROWS, not just cells

[CRAIG20]

Hi I am looking for a way to highlight exact match (duplicate) rows. I know how to do this for individual cells in conditional formatting but I have 2000 rows and I want to check for duplicated rows.

Thanks in adavance.

 

[etaf]

how many columns ?
=COUNTIFS($A$2:$A$50,$A2,$B$2:$B$50,$B2,$C$2:$C$50,$C2,$D$2:$D$50,$D2) >1

Book2
	A	B	C	D
2	a	b	c	1
3	a	b	c	d
4	a	c	f	g
5	1	b	c	d
6	a	b	c	d
7	a	c	f	g
8	a	b	1	d
9	a	c	f	g
10
11
12
13
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D16	Expression	=COUNTIFS($A$2:$A$50,$A2,$B$2:$B$50,$B2,$C$2:$C$50,$C2,$D$2:$D$50,$D2)>1	text	NO

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)