title: Highlight with exeption Excel VBA
body: <p>I need help figuring out how it's possible to highlight duplicates but not highlight or compare to values that has &quot;IMD Exempel&quot; in column A.</p>
  <p>This is my code right now but it highlights every duplicate.</p>
  <pre><code>Dim Rng As Range
  Dim cel As Range
  Set Rng = Range(Range(&quot;C8&quot;), Range(&quot;C&quot; &amp; Rows.Count).End(xlUp))
  For Each cel In Rng
      If WorksheetFunction.CountIf(Rng, cel.Value) &gt; 1 Then
          cel.Interior.Color = RGB(255, 255, 153)
      Else
          cel.Interior.ColorIndex = xlNone
      End If
  Next cel
  </code></pre>
  <p>In this example screenshot I would like none to be highlighted.</p>
  <p><img src="https://i.stack.imgur.com/rZNt0.jpg" alt="Screenshot" /></p>
  <p>Thanks in advance!</p>