Template with rules doesnt modify the table when is paste on excel

Help Studio
,
1

i have a template with rules that modify cells colors and colors numbers, when the robot paste the info from table with write range activity over the template this is still in blank but if i open same workbook manually i see the rules are still there and if i click the cell then the color change

how can i “wake up” the colors from excel before i send it to mail.

image

image

thanks

2

Hi @amy93amanda

Please correct me if I’m wrong. Do you want to remove the colors from the excel? If yes please check the below flow. If I’m wrong please correct me, Thank You.

With below code cell colors can be removed from the EXCEL.
VBA Code:

Sub RemoveCellColors()
    Cells.Interior.ColorIndex = xlNone
End Sub

image
image880×1615 58 KB

Regards

3

Hi @amy93amanda,

Are you using workbook activities or excel activities? Please use excel activities.

1 Like
4

nop, i need to keep the colors

these are in white
image
but i have some rules that detect if the time are > or < than something then bring a color
image
but using robot doesnt detect that new data is there and i have to open excel and click manually the cell to obtain the color

i need to paste data and excel detect is there

6

Hi @amy93amanda

Please share the conditions and sample Input excel file, I will try to provide the code based on your conditions.

Regards