Conditional Formatting or COUNTIFS formula for duplicate rows?

[AG07509]

Hello,

I have a spreadsheet with 5,000 plus rows and many of the rows containduplicate data. What I am trying to do is if Column A has a duplicate thencompare the data in those rows and if the entire row is a duplicate to somehowidentify them from conditional formating or a formula like COUNTIFS.
Example: A3 and A4 are duplicates so I need to check tosee the remaining part of these two rows are identical.
Is this possible?

	A	B	C	D	E	H	I	J	K
1	Case Number​	Service From Date​	Service To Date​	Year​	REVIEW TYPE​	CASE TYPE​	DXC CODE​	DXC DESC​	PXC CODE​
2	9351528	9/22/2016	9/22/2016	2016 - Q3	Medical	Outpatient	I4891	Unspec atrial fibrillati	93228
3	9351605	10/26/2016	10/26/2016		Medical	Outpatient	I480	Paroxysmal atrial fibril	33282
4	9351605	10/26/2016	10/26/2016		Medical	Outpatient	I480	Paroxysmal atrial fibril	33282
5	9352003	1/9/2017	1/10/2017	2017 - Q1	NULL	Outpatient	R008	Other abnormalities of h	33282
6	9353964	11/7/2016	11/7/2016		Medical	Outpatient	R002	Palpitations	93228
7	9353977	11/23/2016	11/23/2016		Medical	Outpatient	R002	Palpitations	93228
8	9358036	2/16/2016	2/16/2016	2016 - Q1	Medical	Outpatient	R002	Palpitations	93229
9	9358036	2/16/2016	2/16/2016	2016 - Q1	Medical	Outpatient	R002	Palpitations	93229

<tbody> </tbody>

 

[Joe4]

Welcome to the Board!

Select cells A2:K9, go to Conditional Formatting, and enter this Conditional Formatting formula:

=OR(AND($A2=$A1,$B2=$B1,$C2=$C1,$D2=$D1,$E2=$E1,$F2=$F1,$G2=$G1,$H2=$H1,$I2=$I1,$J2=$J1,$K2=$K1),AND($A2=$A3,$B2=$B3,$C2=$C3,$D2=$D3,$E2=$E3,$F2=$F3,$G2=$G3,$H2=$H3,$I2=$I3,$J2=$J3,$K2=$K3))

and choose the red font color.

 

[AG07509]

Welcome to the Board!

Select cells A2:K9, go to Conditional Formatting, and enter this Conditional Formatting formula:

=OR(AND($A2=$A1,$B2=$B1,$C2=$C1,$D2=$D1,$E2=$E1,$F2=$F1,$G2=$G1,$H2=$H1,$I2=$I1,$J2=$J1,$K2=$K1),AND($A2=$A3,$B2=$B3,$C2=$C3,$D2=$D3,$E2=$E3,$F2=$F3,$G2=$G3,$H2=$H3,$I2=$I3,$J2=$J3,$K2=$K3))

and choose the red font color.

Worked perfectly. Thank you very much.

 

[Joe4]

You are welcome!

It is a bit long, but the logic is quite simple. It is simply checking to see for any row, if all the columns have the same values as the row above or row below.

 

[jtakw]

Hi,

Just another way:

=OR(SUMPRODUCT(--($A2:$K2=$A3:$K3))=11,SUMPRODUCT(--($A2:$K2=$A1:$K1))=11)