Set color with number( values)

[Aarthy1 (Aarthy)]

Hi

I need to set the color on one whole columns ,but the rows count is changing dynamically ( like this jan month file has 100 rows , Feb month file 469 rows ) in that i want to color A clm the color value is #CCFFF

[Anil_G (Anil Gorthi)]

@Aarthy1

If you need column A full then use set color with A:A

Else read the data and use "A1:A"+ dt.rowcount.ToString

Cheers

[supermanPunch (Arpan)]

Hi @Aarthy1 ,

If the “How to Color” part is still not clear yet, In Addition to @Anil_G 's method of Selection of Rows for coloring, you could use the Format Cells Activity to color the desired range/Column.

Let us know if you are still facing issues and maybe explain at what step is the difficulty being faced.