conditionalFormat: Add conditional formatting to cells

Description Usage Arguments Details Author(s) See Also

Description

DEPRECATED! USE conditionalFormatting

Usage

1
2
conditionalFormat(wb, sheet, cols, rows, rule = NULL, style = NULL,
  type = "expression")

Arguments

wb

A workbook object

sheet

A name or index of a worksheet

cols

Columns to apply conditional formatting to

rows

Rows to apply conditional formatting to

rule

The condition under which to apply the formatting or a vector of colours. See examples.

style

A style to apply to those cells that satisify the rule. A Style object returned from createStyle()

type

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.

Details

DEPRECATED! USE conditionalFormatting

Valid operators are "<", "<=", ">", ">=", "==", "!=". See Examples. Default style given by: createStyle(fontColour = "#9C0006", bgFill = "#FFC7CE")

Author(s)

Alexander Walker

See Also

createStyle



Search within the openxlsx package
Search all R packages, documentation and source code

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.