CODEWITHSUNDEEP
google-sheets
Michael
Michael

Reputation: 3

Highlight row based on duplicate cell contents google sheets

The answer in this question Highlighting Duplicate Rows in Google Sheets works perfectly to highlight the duplicate cells in a column. What I'm wanting to do is one step futher and highlight the rows that each of those duplicated cells are in.

So if I've got duplicated cells in column c that are highlighted, how do I also highlight the rows?

Thanks!

Here's the current formatting I have to highlight duplicates in Column C.

Current conditional formatting equation

Upvotes: 0

Views: 8555

Answers (1)

Ed Nelson
Ed Nelson

Reputation: 10259

Change Apply to range to A1:Z (change Z to last column you want to highlight). And change the Custom formula to =countif($C:C,$C1)>1. You need to use the absolute reference ($).

Upvotes: 1

Related Questions