Set color with number( values)


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


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

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


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.