Skip to content

FormulaRule

Source code

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
  )
)