excel

[farshad]

Hi,

Using VB.NET how is it possible to change the colour of the cells (NOT the texts in the cell) of a row or an individual cell in excel.

 

Thanks

[dynamic_sysop]

if you want to set the back color of the cells, you can use something like this...

'/// where objSheet is an excel.Worksheet
objSheet.Cells(1, 1).Interior.ColorIndex = 45 '/// 45 being the color ( red i think ) just mess with the values to see what colors appear.