I am using VB.NET. I want to change excel's cell color. I create a style as follows:
Dim HeaderStyle As Excel.Style = gExcelBook.Styles.Add("HeaderStyle")
.Font.Name = "Tahoma"
.Font.Size = 11
.Font.Color = Color.Blue
.Font.Bold = True
.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter
My problem is that Font.Color = Color.Blue causes a run time error such as "Type mismatch."!
Do you have any idea for this?
Color = RGB(255, 0, 0)
To set the color