yes. It could be a bit simplified but its correct
vb.net Code:
With Worksheets("sheet1").Range("A:B") .FormatConditions.AddUniqueValues .FormatConditions(Selection.FormatConditions.Count).SetFirstPriority .FormatConditions(1).DupeUnique = xlDuplicate .FormatConditions(1).Font.Color = vbRed End With




Reply With Quote