format_column_where

The format_column_where method applies color formatting to a column of the source table, based on user-specified conditions.

Syntax

Parameters

ParameterTypeDescription
colstr

The column name.

condstr

The condition expression.

formulastr

Formulas to compute formats for columns or rows in the table; e.g., "X = Y > 5 ? RED : NO_FORMATTING". For color formats, the result of each formula must be either a color string (such as a hexadecimal RGB color, e.g. "#040427"), a Color, or a packed long representation of the background and foreground color (as returned by bgfg() or bgfga()).

For decimal formats, the result must be a string, and the formula must be wrapped in the special internal function Decimal(); e.g., "X = Decimal(`$#,##0.00`)".

Returns

A new table that applies the specified formatting to the source table.

Examples

In the following example, we use format_column_where to paint the "X" column red where the value is greater than 2.