Hi All, Good Morning! I am trying to perform Conditional formatting. I.e. I have an excel from that using a Column(RRN) if any duplicate values found I want to mark that duplicate values in light red colour. If the column contains unique value then I don’t want to do anything(it should be white …

Great … it helped you. Please could you close this and mark it as the solution to your query so that it helps others… Just make the below change, if you want to change the colour of RRN column which is column C as per your excel Set Range Color Activity: Range as “C”+intExcelIndex.ToString+“:C”…

How to perform Conditional Format using Uipath

Help Activities

HeartCatcher (Naveenkumar.S) September 24, 2021, 5:13am 2

Book.xlsx (12.8 KB)

Topic		Replies	Views
Conditional Formatting duplicate values Learn datatable , excel	8	2074	June 15, 2020
Highlight duplicate value in excel using uipath Activities excel , activities , studio	3	1248	September 24, 2021
I want to create new rule in conditional formatting in excel Help excel , activities , question	1	1196	December 3, 2020
Excel Automation: Conditional Formatting Activities excel , uiautomation , studio , question	0	795	December 12, 2020
Color Cells in Red based on column condition Help	3	2238	October 29, 2018

Most Active Users - Yesterday
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE
More details...

How to perform Conditional Format using Uipath

Related Topics