how can I change color for specific rows?
There is an activity called set range color, which used to set color on excel cells.
Or you can also use excel VBA for changing the cell color.
but how do I then get the range?
Range will be like ,
You can get row index by
And set the range by,
“A” + Kortlana.rows.index(row).tostring + “:Z” + Kortlana.rows.index(row).tostring
Change z with the last column of your excel.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.