formatColumnWhere

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

Syntax

Parameters

ParameterTypeDescription
columnNameString

The column name.

conditionString

The condition expression.

formulaString

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 formatColumnWhere to paint the "Timestamp" column red where the value of "X" is between 2 and 5.