How i get set range color activity in New Uipath Version

Help Activities
, ,
1

Hi,

How i get "Set Range Color Activity in New UiPath Version

Navnit

2

@Navnit_Ghadigaonkar

You can use format cells activity in the modern design for filling color

Alternately you can see the classic activities by following this 
Activities → click filter icon → select classic 
now you would see the activity

Cheers

3

Gr8
thanks Its working

1 Like
4

@Navnit_Ghadigaonkar

Happy Automation

Please mark solution so that others with similar issue can get help

Cheers

5

Hi Anil @Anil_G ,

One question. Doesn’t modern Excel package support Get/Set cell/range color activity? why my modern excel package provide "Get cell color " activity but with no “Set range color” activity? What does this mean? Support or not support?

I would like to format the cell with color_variable extracted from “Get cell color”, Can I only use classic activities?

Thanks.

image
image2455×687 76.2 KB

6

@LeonJia

in modern you have format cells activity

cheers

7

Hi @Anil_G I want to set up the cell with the same color as a specific cell. The Format Cells activity doesn’t support color variables, Does it?

Thanks

8

@LeonJia

Yes you cannot

if you still need it classic set range color can be used
in modern activities as well

else can use copy paste range with formats only option

image
image717×388 11.5 KB

cheers

1 Like
9

Thanks for the very helpful advice.

1 Like