Change font colour

[sruthesanju]

Need to change font colour of cell to grey using vb.net script

[muhammedyuzuak]

Hi @sruthesanju,

You can check this topic.

Dim style As Excel.Style = xlWorkSheet.Application.ActiveWorkbook.Styles.Add("NewStyle")
style.Font.Bold = True
style.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Yellow)

xlWorkSheet.Cells(rownumber, 1).Style = "NewStyle"

Changing cell color of excel sheet via VB.NET

[sruthesanju]

Excel.style is not defined error

[Rahul_Unnikrishnan]

Hello @sruthesanju

Is it mandatory to use Vb.net?

Else please use the activity Format Cell to meet the requirement.

Format Cells

[sruthesanju]

It’s manadatory use vb.net

[sruthesanju]

I need to change the font colour not background colour plese to find code for this script

[sruthesanju]

Any one can reply please

[supermanPunch (Arpan)]

Hi @sruthesanju ,

Have you Checked the post below :

How to change the font color in the excel cell

@Vrushali_Gave colIndex refers to the Index of the Column and not the column name, According to the Workflow that you have provided you need to use Now.ToString(“dd”) as the column name for identification of the column to be updated in the DT. But to Change the Color of the Updated value in the Excel you would need to have the column names of the Excel i.e A, B, C, … I have recognised that you have not used the Number To Letter workflow for retrieving the Column Name of the excel dynamically,…