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!

John Doe	Toyota	2013
John Doe	Toyota	2013
John Doe	Toyota	2015
John Doe	Toyota	2015
John Doe	Toyota	2016
Jane Doe	Toyota	2013

<tbody>
</tbody>

 

[AliGW]

How about this?

Excel 2016 (Windows) 32 bit

	A	B	C	D
1	John Doe	Toyota	2013
2	John Doe	Toyota	2013
3	John Doe	Toyota	2015	Change
4	John Doe	Toyota	2015
5	John Doe	Toyota	2016	Change
6	Jane Doe	Toyota	2013	Change

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet5​

Worksheet Formulas Cell Formula D2 =IF(AND(A2=A1,B2=B1,C2=C1),"","Change") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>