Hi,

I would like to set the cell background color (and font color later) for a
range of cells in excel using a c# application.

First I set the BackColor of a textbox on a windows form to the color I
would like to apply to the Excel cell/range. the color in this case is
RGB(255,128,128) or {RGB=0xffff8080} from the colorDialog.

The following works fine but I need to replace the "255" with the Backcolor
of the textbox.

rng = (Excel.Range)ws.Cells[2,2];
ws.get_Range(rng,rng).Interior.Color  = 255;  Red
or
ws.get_Range(rng,rng).Interior.Color  = 65535;  Yellow

In vba I can use :

Cells(1, 1).Interior.Color = RGB(255, 128, 128)

But I haven't managed to get the automation from c# to work.

Any assistance welcome :-)

Cheers
Olan