conditionalFormat

sheet

Columns to apply conditional formatting to

cols

rows

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

rule

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

style

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.

type


DEPRECATED! USE <code><a rd-options="" href="/link/conditionalFormatting?package=openxlsx&version=4.0.0" data-mini-rdoc="openxlsx::conditionalFormatting">conditionalFormatting</a></code>


Simplifies the creation of Excel .xlsx files by providing a
high level interface to writing, styling and editing worksheets. Through
the use of 'Rcpp', read/write times are comparable to the 'xlsx' and 'XLConnect'
packages with the added benefit of removing the dependency on Java.

Alexander Walker

openxlsx

Read, Write and Edit XLSX Files

conditionalFormat function


DEPRECATED! USE <code><a rd-options='' href='conditionalFormatting'>conditionalFormatting</a></code>


conditionalFormat: Add conditional formatting to cells

Description

Usage

Arguments

Details

See Also