Color duplicate values in a Column on Worksheet event

[fabian_76]

HI, I have in Column "C" invoice# and I can have up to 15 cells with the same invoice#. I want to double click on a specific invoice# get it colored but also I want to color all cells containing the same invoice# in Column "C".

Can someone help?

Private Sub Worksheet_BeforeDoubleClick(ByVal target As Excel.Range, Cancel As Boolean)

If target.Interior.ColorIndex = xlNone Then
    target.Interior.ColorIndex = 3
    ElseIf target.Interior.ColorIndex = 3 Then
    target.Interior.ColorIndex = xlNone
End If
Cancel = True

End Sub