Excel: Set Range Color Dynamically


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?



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

1 Like

Thank you this solution worked.

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

Thank you.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.