setFormat

sets a custom format for a cell and returns the name of the format

string setFormat(number rowId,number columnId,string format, [string page] );

rowId	number	the row id
columnId	number	the column id
format	string	conditions for formatting the cell content, separated by semi-colons
page	string	optional, the name of the sheet

string

the name of the format

$$("ssheet").setFormat(2, 2, "[>1000]> 0.0;[>100]Check 0,000.0#;[=0]Nope", "Sheet1");

Details

When a new column or row is added, new cells inherit the existing formats in the following way:

on adding a new row/rows, new cells inherit the format from the cells of the above row
on adding a new column/columns, new cells inherit the format from the cells of the column to the left