How to update Excel column without for each activity?

[sandipgolande012]

Hello,
Is there any alternate option to update excel column instead for each.

consider below column:

Column_A
1000
2000
3000
4000

I want update column with currency symbol or With color, i have achieved this using for each (using: Format value activity for update currency & Set Range Color for update color) but, it’s taking too much time.

please guide me.

[Priyanka_Ramesh]

Hi ,
Same activity as mentioned can be used. Then Try autofill Range to fill the Same in Rest of the rows.

@sandipgolande012

using: Format value activity for update currency & Set Range Color for update color

[sandipgolande012]

Thank you… @Priyanka_Ramesh