Sub test()
Call fc_uni([c3:j10])
Call fc_uni([c13:j20])
End Sub
Sub fc_uni(rng As Range)
Dim uv As UniqueValues
Set uv = rng.FormatConditions.AddUniqueValues
uv.DupeUnique = xlDuplicate
' uv.Interior.Color = RGB(255, 199, 206)
uv.Font.ColorIndex = 3
uv.Font.Bold = True
End Sub
Sub test()
Call uni([c3:j10])
Call uni([c13:j20])
End Sub
Sub uni(x As Range)
Dim d, y, v, a, t
Set d = CreateObject("scripting.dictionary")
For Each y In x
v = y.Value
a = y.Address
If v <> "" Then If d.exists(v) Then t = t & "," & d(v) & "," & a Else d(v) = a
Next
If t = "" Then Exit Sub
With Range(Mid(t, 2)).Font
.Color = vbRed
.Bold = True
End With
End Sub