title: If the row contains specific text highlight row by row where two columns are the same
body: <p>I currently use conditional formatting on columns M and N on a spreadsheet to fill duplicate number values using the formula:</p>
  
  <p><code>=COUNTIF($M1:$N1,M1)&gt;1</code></p>
  
  <p>I was asked by my boss if I could only conditionally format columns M and N if a specific text name in column G appears on that same row. Is there a way to add this to my formula or would this need something different?</p>