@all

Apply to all cells in the table.

Cell identifier. You can identify cells using either the column letter and row number (e.g., “A1”), or by using “R” followed by the row number followed by “C” and the column number (e.g., “R1C2”).You can optionally add an ‘if’ condition to the identifier. Without the ‘if’ condition, the formatting will be applied to all the identified cells. If an ‘if’ condition is supplied, the formatting will be applied to all the identified where the ‘if’ condition is true. The ‘if’ condition must be followed by a boolean expression.

row[,] col

Row number, followed by column letter or number (e.g., “2,C”, or “2,3”), separated by “,”. Apply to cell.

Row number (e.g., “2”). Apply to all cells in the row.

Column letter (e.g., “B”). Apply to all cells in the column.

first_cell[:]last_cell, first_cell[,]last_cell

Top left cell of the selection range (specified in “cell” format), followed by bottom right cell of the selection range (specified in “cell” format), separated by a “:” or “,” (e.g., “A2:C10”, “A2,C10”, or “R2C1:R10C3”, “R2C1,R10C3”). Apply to all cells in the rectangular region defined by the first cell and last cell.

first_cell_row[,] first_cell_col[,] last_cell_row[,] last_cell_col

Top left cell of the selection range (specified in “row[,] col” format), followed by bottom right cell of the selection range (specified in “row[,] col” format), separated by a “,” (e.g., “2,A,10,C” or “2,1,10,3”). Apply to all cells in the rectangular region defined by the first cell and last cell.

mode=arg

Color mode: “Alt” (alternate and color every other row in the cell_range); “All” (color every row in the cell_range).