Change cell color if row.item(0) > 500

Help Studio
1

Hi,
how can I change color for specific rows?

image
image731Ɨ611 12.7 KB

2

Hi @markosc

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.

Thanks

1 Like
3

but how do I then get the range?

4

Range will be like ,

You can get row index by

Kortlana.rows.index(row)

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.

Thanks

1 Like
5

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