Highlighting Rows with Unique Value within Duplicate Data

[lp1937]

Hi, I have a set of data and I need to be able to find a formula that looks at the prior rows and the highlight any changes. For example, Row 3, 5, and 6 will be highlighted here.

I tried using a helper formula to concatenate the columns and then a conditional formatting with a countifs > 1 formula, but that doesn't work as there is two John Doe values and I tried another conditional formatting with C2<>C3 but that doesn't work as Jane Doe will not mark a change.

Any help would be appreciated!

[TABLE="width: 500"]
<tbody>[TR]
[TD]John Doe[/TD]
[TD]Toyota[/TD]
[TD]2013[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Toyota[/TD]
[TD]2013[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Toyota[/TD]
[TD]2015[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Toyota[/TD]
[TD]2015[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]Toyota[/TD]
[TD]2016[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]Toyota[/TD]
[TD]2013[/TD]
[/TR]
</tbody>[/TABLE]

 

[AliGW]

How about this?

Excel 2016 (Windows) 32 bit

	A	B	C	D
John Doe	Toyota
John Doe	Toyota
John Doe	Toyota	Change
John Doe	Toyota
John Doe	Toyota	Change
Jane Doe	Toyota	Change

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]2013[/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]2013[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]2015[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]2015[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]2016[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]2013[/TD]

</tbody>

Sheet5​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]D2[/TH]
[TD="align: left"]=IF(AND(A2=A1,B2=B1,C2=C1),"","Change")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]