Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change cell color but it doesn't change | Excel Worksheet Functions | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
change cell color to red & then green when value change in 2 cel | Excel Discussion (Misc queries) | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) |