How To Change Colour Of Cell During an Iteration

Help Studio
, ,
1

Hi,
I am using a for each row activity, I want to change the colour of each cell after every iteration.
How can this be done?

1 Like
2

@ADITYA_MUKHERJEE

Use Set Range Color activity to set the color to excel cells and you need to pass the range of the cells.

3

how to get the range of the cells?

4

@ADITYA_MUKHERJEE

Suppose you want to apply colors to D column.

                ForEach row in inputDT
                     int index =  inputDT.Rows.IndexOf(row) + 2
                        Range: "D"+index.Tostring

Where inputDT is your input dataTable.
If Excel file contains headers then use +2 else +1

6 Likes
6

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