Change the font colour

Hi @sruthesanju

Please try the below method.

  1. 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

  1. Use invoke code activity to execute the above code. Attached screen shot for your reference.

image

Feel free to reach us at any time if you have any doubts. Thanks.

Happy Automation