Hi guys,

I'm having difficulties with creating a macro. The scenario: The macro needs to search in column I for a cell with a red background (Interior.ColorIndex = 3). Then it needs to search for duplicates of the value from that same cell in column I. If there's a match, then it needs to give it the same color.

Example:
Cell I1 until I13 have white background. Cell I14 has a red background with value 125. The macro needs to search in column I for value 125 and colour it red.

I hope that you can help me.

Cheers,

Flunzy