Excel: Set Range Color Dynamically

[MF.RPA (M.Farrell)]

Hello,

I am having trouble applying the “set range color” activity to an excel file dynamically.

I need to set the color range in column P for each row in my excel file that contains data.

I have tried using a counter and index variable but I have not had any success.

Could someone recommend a solution?

e

[keerthi3595 (Keerthana M)]

Hi @MF.RPA

If you want to colour the whole column in a excel table

Please change the index variable assignment
Index= updatedfile.rows.count+1
Do not add double quotes to this expression
Index should be variable type integer

Please change address the set range variable it should be “P1:P”+index.tostring

[MF.RPA (M.Farrell)]

@keerthi3595

+index.tostring

Thank you this solution worked.

I think I just overlooked the obvious after spending too much time at the keyboard.

Thank you.