How to perform Conditional Format using Uipath

HI @HeartCatcher

Check with the below vba Code!

Sub testmacro()
'declare variables
Dim ws As Worksheet
Dim ColorRng As Range
Dim ColorCell As Range
Set ws = Worksheets("Sheet1")
Set ColorRng = ws.Range("C2:C13")
'highlight cells that contain duplicate values in the selected range
For Each ColorCell In ColorRng
If WorksheetFunction.CountIf(ColorRng, ColorCell.Value) > 1 Then
ColorCell.Interior.Color = RGB(255, 127, 127)
Else
ColorCell.Interior.ColorIndex = xlNone
End If
Next

End Sub

Regards