How to highlight Duplicate Values and Filter by Colour

[Jagadesh2494 (Jagadesh)]

Hello,

I have excel data where i have put concatenate. Now i need to select that particular column and highlight the duplicate values. After highlighting the duplicate values i need to filter them by color. Someone please help me on this.

Thank you.

[sarathi125 (Parthasarathi)]

Hi @Jagadesh2494,

Do you want to do this using excel options, if yes then you can do it by navigating to the “Conditional Formatting” → Highlight Cell Rules → Duplicate values.

If you need to do the same from UiPath then select that column using UiPath then follow the same steps from UiPath as mentioned above.

[AshwinS2 (Ashwin S)]

Hi @Jagadesh2494

Use set range color based on the condition to check the duplicate

Thanks
Ashwin.S