farshad Posted August 26, 2003 Posted August 26, 2003 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 Quote Farshad
Leaders dynamic_sysop Posted August 27, 2003 Leaders Posted August 27, 2003 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. Quote
Recommended Posts