title: Check if row contains ANY value *more than once*
body: <p>I am doing data analysis and sometimes I need to check and to make sure each row in excel does not have any repeated value. I hope that there is a formula where each time if there's a repeated value in the same row, the value will be highlighted and it doesn't matter what value it is, as long as it's repeated in the same row. </p>
  
  <p>I try to search it everywhere but the closest I can find is below question &amp; answer ( which couldn't apply to me as I need a formula that can highlight any value that's repeated and not only zero):</p>
  
  <p>I have rows which contain grades for students (numerical values), where the number 0 means they missed a class.
  I want the row to be highlighted in one color if they have "0" 3 or 4 times, and in another color if they have "0" 5 times or more.</p>
  
  <pre><code>=COUNTIF(1:1,0)&gt;=5
  </code></pre>
  
  <p>Anyone can help me?
  Thanks in advance!</p>