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

pravin_calvin (pravin kumar) September 24, 2021, 6:23am 6

Hi @HeartCatcher

Use Excel application scope inside that use macros!

Enable trust Centre setting in excel application!

Excel options---->TrustCentre—>trustcentreSettings–>macro Settings—.>EnableVBA Macros–.ClickOk

Regards

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

Most Active Users - Yesterday
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu
More details...

How to perform Conditional Format using Uipath

Related Topics