Hi @sruthesanju
Please try the below method.
- Create a text file and past the below vb.net code.
Public Function color()
Dim rangeToFormat As Excel.Range
rangeToFormat = xlWorkSheet.Range(“B1”, “B1”)
rangeToFormat.Interior.Color = RGB(255,0,0)
End Function
- Use invoke code activity to execute the above code. Attached screen shot for your reference.
Feel free to reach us at any time if you have any doubts. Thanks.
Happy Automation