Highlight row based on duplicate cell contents google sheets

Question

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

Answer 1

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 ($).