How to highlight Duplicate Values and Filter by Colour


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.

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.

Hi @Jagadesh2494

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