backColor Method

Gets or sets the background color for the cell, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.CellRange(sheet, row, col, rowCount, colCount, sheetArea);
var returnValue; // Type: any
returnValue = instance.backColor(value);

function backColor( 
   value : string
) : any;

Parameters

value: The cell background color.

Return Value

If no value is set, returns the cell background color; otherwise, returns the cell.

Example

The following examples set the backcolor.

Javascript

activeSheet.getRange(2, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).backColor("lightblue");

Javascript

activeSheet.getCell(1,1).backColor("lightgreen");

Javascript

activeSheet.getRange(-1, 3, -1, 1, GC.Spread.Sheets.SheetArea.viewport).backColor("pink");

Remarks

You can reset the cell backcolor by setting the value to undefined. For example, activeSheet.getCell(1, 1).backColor(undefined);.

Reference

CellRange type
Setting Colors