Change a cell color
I have a c# program that builds a 2-d string array and copies it to a range
with a single statement similar to: oRange.set_Value( Type.Missing, myArray );
If my array looked like [0,0]="FOO1" [0,1]="BAR1" [1,0]="FOO2" [1,1]="BAR2",
then in Excel I end up with A1=FOO1, B1=BAR1, A2=FOO2, B2=BAR2
Suppose I want some text in color or italics, is there any formula or
function that I can embed in the text, e.g. "=ITALIC(FOO1)" that would give
the desired formatting when the array is read into the spreadsheet?
I need a solution that does not involve VBA, and everything that I have
googled uses Excel conditional formatting or vba, which won't help me.
Hope someone can help.
Regds
--
G.R.Stanbury
|