Conditional Formatting, Text and Suppression Criteria and Parameters

Conditional Formatting/Text Criteria and Parameters

Type Definition Reference Value Operator Comparison Options
Cell Value Data value (numeric, text or date) in a specified cell Enter the cell reference defined by the column and row (for example, A,1).

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter data value)

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Row Value Data value in a specified row Select row number from a list of rows in the table.

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter data value)

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Column Value Data value in a specified column Select column number from a list of columns in the table.

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter data value)

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Current Cell Value Data value in the current cell Not applicable

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter data value)

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Position Within First or last row or column of a data segment with multiple members or a member function. Select either Row or Column

Is

Is Not

 Select either Top Row/Column or Bottom Row/Column.
AttributeValue Attribute value that applies to a cell, row or column Select an Attribute from a list of Attributes in the schema

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Select an Attribute Value from the list of values in the schema
AttributeAlias Attribute alias that applies to a cell, row or column Select an Attribute from a list of Attributes in the schema
  • equals
  • not equals
  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for the Attribute alias

Conditional Suppression Criteria and Parameters

Type Definition Reference Value Operator Comparison Options
Cell Value

Based on the data type of the specified cell, it can be:

  • Numeric Value

  • Date

  • Smart List

  • Text

 Enter the cell reference defined by the column and row (for example, A,1).

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter numeric, text, smart list, or date value)

    Note: Not for Text type.

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Data Values in Row Data value in a specified row Select row number from a list of rows in the table

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter numeric, text, smart list, or date value)

    Note: Not for Text type.

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Data Values in Columns Data value in a specified column Select column number from a list of columns in the table

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter numeric, text, smart list, or date value)

    Note: Not for Text type.

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Data Values in Current Row/Column Data value in a current row or column Not Applicable

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter numeric, text, smart list, or date value)

    Note: Not for Text type.

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
AttributeValue Attribute value that applies to a cell, row or column Select an Attribute from a list of Attributes in the schema

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Select an Attribute Value from the list of values in the schema
AttributeAlias Attribute alias that applies to a cell, row or column Select an Attribute from a list of Attributes in the schema

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for Attribute dimension