vba for Highlight duplicate value in different array or range

[ratnesh darne]

I want to highlight duplicate value in different array or range,

If my value in cell D5 and i want to match with any cell between range A1:D4 if match then both cell should be highlight.

 

[VoG]

Maybe like this

Sub dups()
Dim c As Range
For Each c In Range("A1:D4")
    If c.Value = Range("D5").Value Then Union(c, Range("D5")).Interior.Color = RGB(255, 0, 0)
Next c
End Sub

 

[ratnesh darne]

Not working, The same function dose not show in function list.

 

[VoG]

Not working,

Not helpful. It isn't a function it is a subroutine. ALT + F8 and run the macro.