title: Highlight duplicate value from second instance with red color , from hole sheet range(UsedRange)
body: <p>I tried with below macro code but its not highlighting duplicate from 2nd instance Plz help me out </p>
  
  <p>And one more thing iam trying to do with Dynamically not taking fixed range  (Particular range)</p>
  
  <pre><code>Sub FindingDuolicate()
      Dim Rng As Range
      Dim rngCell As Variant
      Dim Flag As Long
      ActiveSheet.UsedRange.Select
      Flag = 0
      For Each Rng In Selection
          If (WorksheetFunction.CountIf(Selection, Rng.Value) &gt; 1) Then
              Rng.Interior.Color = vbRed
              Flag = Flag + 1
          Else
              Rng.Interior.Pattern = xlNone
          End If
      Next
      If Flag &gt; 0 Then
          MsgBox Flag &amp; " Cells (in red) Contain an Duplicate Data. Please Check"
      Else
          MsgBox " Data Validation Completed . No Duplicate Found. "
      End If
  End Sub
  </code></pre>