If the row contains specific text highlight row by row where two columns are the same

Question

I currently use conditional formatting on columns M and N on a spreadsheet to fill duplicate number values using the formula:

=COUNTIF($M1:$N1,M1)>1

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?

Answer 1

Maybe add an AND to your formula:

=AND($G1="name",COUNTIF($M1:$N1,M1)>1)