workbook.createConditionalFormatRule(options)

Method Description

Creates a conditional format rule.

Returns

workbook.ConditionalFormatRule

Supported Script Types

Server scripts

For more information, see SuiteScript 2.x Script Types.

Governance

None

Module

N/workbook Module

Sibling Module Members

N/workbook Module Members

Since

2021.2

Parameters

Note:

The options parameter is a JavaScript object.

Parameter

Type

Required / Optional

Description

options.filter

workbook.TableColumnFilter

required

A filter indicating when the conditional format rule should be applied.

options.style

workbook.Style

required

The style to use for the conditional format rule.

Syntax

Important:

The following code sample shows the syntax for this member. It is not a functional example. For a complete script example, see N/workbook Module Script Samples. Also see Full scripts in the Tutorial: Creating a Workbook Using the Workbook API topic.

            // Add additional code
...
var myConditionalFormatRule = workbook.createConditionalFormatRule({
    filter: formatFilter,  // previously created workbook.TableColumnFilter
    style: formatStyle     // previously created workbook.Style
});
...
// Add additional code 

          

Related Topics

General Notices