FormulaRule
Description
Conditional formatting with custom differential style
https://openpyxl.readthedocs.io/en/stable/api/openpyxl.formatting.rule.html
Usage
FormulaRule(
formula = NULL,
stopIfTrue = NULL,
font = NULL,
border = NULL,
fill = NULL,
...
)
Arguments
formula
|
formula |
stopIfTrue
|
stopIfTrue |
font
|
font |
border
|
border |
fill
|
fill |
…
|
Additional arguments, i.e. kwargs. |
Value
An openpyxl Python object.
Examples
library("xlcharts")
wb <- Workbook()
ws <- wb$active
ws$conditional_formatting$add('E1:E10',
FormulaRule(
formula = list('ISBLANK(A1)'),
stopIfTrue=TRUE
)
)