Q:

Is it possbile to set two different text color in excel cell programatically

I'm trying to find a way to change the color of a line of text in an excell cell
programatically. I know how to change the backcolor of a cell but not the text color.
  Dim style_green As Excel.Style = xlSheet.Application.ActiveWorkbook.Styles.Add("Green")

  xlSheet.Cells(1, 1).Style = "Green"

For example I would like to have 3 lines in a cell
line1 - color blue
line2 - color red
line3 - color green
Is this possible?

A:

cYou Can change it using:
xlSheet.Cells(1, 1).Characters(Start,Length).Font.Color = vbRed

But you need to find Start and Length parameters for each line first.

