title: Highlight row based on duplicate cell contents google sheets
body: <p>The answer in this question <a href="https://stackoverflow.com/questions/38274708/highlighting-duplicate-rows-in-google-sheets]">Highlighting Duplicate Rows in Google Sheets</a> 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. </p>
  
  <p>So if I've got duplicated cells in column c that are highlighted, how do I also highlight the rows?</p>
  
  <p>Thanks!</p>
  
  <p>Here's the current formatting I have to highlight duplicates in Column C.</p>
  
  <p><a href="https://i.stack.imgur.com/J3TBG.png" rel="nofollow noreferrer">Current conditional formatting equation</a></p>