DEPRECATED! USE conditionalFormatting
conditionalFormat(wb, sheet, cols, rows, rule = NULL, style = NULL,
type = "expression")A workbook object
A name or index of a worksheet
Columns to apply conditional formatting to
Rows to apply conditional formatting to
The condition under which to apply the formatting or a vector of colours. See examples.
A style to apply to those cells that satisfy the rule. A Style object returned from createStyle()
Either 'expression', 'colorscale' or 'databar'. If 'expression' the formatting is determined by a formula. If colorScale cells are coloured based on cell value. See examples.
DEPRECATED! USE conditionalFormatting
Valid operators are "<", "<=", ">", ">=", "==", "!=". See Examples. Default style given by: createStyle(fontColour = "#9C0006", bgFill = "#FFC7CE")