Set color for particular cell in excel

[pratyush3410]

Hi ,

Need a requirement to set a color to particular cell based on some value ,
Any function or activities available

[nikhil.girish]

Hi @pratyush3410

Check this out

Hope this helps

How to set colour in particular cell in Excel

Hi @mohan2 Read each cell value and check with if condition and then use Set Range Color activity. Set Range Color activity to set a color for a range(“A1:A2”) or a cell(“A1”). To Set Green color use System.Drawing.Color.Green in Color and To Set Red color use System.Drawing.Color.Red in color input. Regards, Vijay Kumar C.

[pratyush3410]

Hi @nikhil.girish

Thanks will follow the steps

[Shiva_Nikhil]

@pratyush3410

yes use set range colour

[mkankatala (Mahesh Kankatala)]

Hi @pratyush3410

You can use the format cells activity, by this activity you can set color to the specific cell.
The Format cells it he modern excel activity, which has to be use inside the use excel file activity.

Hope it helps!!