how to partially change the font color of the words in a excel cell

[neodeaths]

hi all i am using vs.net 2005 to change the excel's cell word partially e.g abc <==where by only the a is red is this possible so far i am able to change the whole cell color with this Excel.Range rng2 = oSheet.get_Range("A1", Missing.Value); rng2.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red); can anyone advice please

[OkkiePepernoot]

//Assuming you did not select the cell yourself rng2.get_characters(1,1).Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red);

[neodeaths]

thanks alot it works very interesting what can be done with c# and excel