Highlight duplicate value in excel using uipath

Hi All,

i want to highlight the duplicate value in excel in yellow color using uipath.
Please help me, as i m new to uipath.


Hi @reetmehta

  • Use Highlight Activity to Highlight the duplicate text in excel
    Check the below workflow
    testPo.xaml (10.1 KB)


Hi Reet,

You can use the “Set Range Colour” activity under App Integration>Excel and the expression “System.Drawing.Color.Yellow” to chose the color yellow.

To find duplicates in your excel, you need to provide some more details so that I can help e.g. Row name, Column name.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.