CODEWITHSUNDEEP
google-sheetsduplicatesformularepeatconditional-formatting
user3153443
user3153443

Reputation: 563

Google sheets, using conditional formatting to match consecutive duplicates

Does google sheets have a way of using conditional formatting to highlight duplicates, but only if they appear consecutively? For example, if I was to use the following spreadsheet:

            Column A
Row 1 | Apple
Row 2 | Tomato
Row 3 | Car
Row 4 | Car
Row 5 | Bus
Row 6 | Apple
Row 7 | Apple
Row 8 | Car

Is it possible to use a formula that would highlight rows 3 and 4, and 6 and 7?

Upvotes: 0

Views: 1387

Answers (1)

TheMaster
TheMaster

Reputation: 50573

Custom formula:

=A1=A2

Apply to 

A1:A100

Or Formula: 

=OR(A2=A3,A2=A1)

Apply to:

A2:A110

Upvotes: 4

Related Questions