Set Color to that Cell

[Shubham_Akole]

How set the color to “Rework Percentage” If the value is greater than equal to 10…

[Krishna_547 (MudhuKrishna)]

Hi @Shubham_Akole,

Loop through the rows and use set color activity in UiPath

Hope it Works

[Shubham_Akole]

But how…?

[Krishna_547 (MudhuKrishna)]

Hi @Shubham_Akole
Check these ,

SetRange Color Parameters ,

[Shubham_Akole]

Please send this file with excel…

[Krishna_547 (MudhuKrishna)]

SetColor.zip (23.0 KB)

[Madhavi (K)]

For better performance, create a macro and execute that macro from UiPath.

[Shubham_Akole]

any Example…?

[Madhavi (K)]

Additionally, you can use conditional formatting as well. In this case, excel will automatically gets updated without you doing any operation apart from writing the data.

How to change background color in Excel based on cell value

To Use Macro,

Excel VBA Macro to Apply Conditional Formatting Based on Value –

[Shubham_Akole]

i want to change 7 no. column what is changes

[Krishna_547 (MudhuKrishna)]

Just update the column alphabet like in the example C is my column in excel , so update accordingly

[RAKESH_KUMAR_BEHERA]

Hey Shubham ji,

I hope this demo will answer your question:

UiPath Tutorial | Set the Color in Cell UiPath | Lookup Data Table UiPath | ExpoHub

[RAKESH_KUMAR_BEHERA]

Hope this demo will work:

UiPath Tutorial | Set the Color in Cell UiPath | Lookup Data Table UiPath | ExpoHub