Link Search Menu Expand Document

SSpread.BackColor Property

Sets the background color for the entire spreadsheet, rows, columns, cells, and cell blocks.

Before setting this property, use the Col, Row properties, and so on to specify what to do.

Specify a color constant or #RRGGBB format. The initial value is $WHITE.

Use the SetOddEvenRowColor method to set a different color for each row (set different colors for even and odd rows). The color of the locked cell takes precedence over the setting of the LockBackColor property.

In the initial state, the background color of the cell is displayed above the grid line. The display order of the background color and grid lines can be changed with the BackColor Style property.

Example of usage

Col = 2;
Row = 3;
BackColor = $YELLOW;
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
BackColor = "#FFEF90";
BlockMode = $FALSE;

Related Items
BackColor Style, ForeColor, LockBackColor property
SetOddEvenRowColor method