# PivotTableCellConditionalFormattingProperty

The cell conditional formatting option for a pivot table.

- Source: Generated code
- Type last changed: v2.93.0 · 23 Aug 2023

## Example

```ts
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { aws_quicksight as quicksight } from 'aws-cdk-lib';
const pivotTableCellConditionalFormattingProperty: quicksight.CfnAnalysis.PivotTableCellConditionalFormattingProperty = {
  fieldId: 'fieldId',

  // the properties below are optional
  scope: {
    role: 'role',
  },
  scopes: [{
    role: 'role',
  }],
  textFormat: {
    backgroundColor: {
      gradient: {
        color: {
          stops: [{
            gradientOffset: 123,

            // the properties below are optional
            color: 'color',
            dataValue: 123,
          }],
        },
        expression: 'expression',
      },
      solid: {
        expression: 'expression',

        // the properties below are optional
        color: 'color',
      },
    },
    icon: {
      customCondition: {
        expression: 'expression',
        iconOptions: {
          icon: 'icon',
          unicodeIcon: 'unicodeIcon',
        },

        // the properties below are optional
        color: 'color',
        displayConfiguration: {
          iconDisplayOption: 'iconDisplayOption',
        },
      },
      iconSet: {
        expression: 'expression',

        // the properties below are optional
        iconSetType: 'iconSetType',
      },
    },
    textColor: {
      gradient: {
        color: {
          stops: [{
            gradientOffset: 123,

            // the properties below are optional
            color: 'color',
            dataValue: 123,
          }],
        },
        expression: 'expression',
      },
      solid: {
        expression: 'expression',

        // the properties below are optional
        color: 'color',
      },
    },
  },
};
```

## Properties

- `fieldId`: string (required) — The field ID of the cell for conditional formatting.

- `scope`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnAnalysis.PivotTableConditionalFormattingScopeProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnAnalysis.PivotTableConditionalFormattingScopeProperty.html) — The scope of the cell for conditional formatting.

- `scopes`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnAnalysis.PivotTableConditionalFormattingScopeProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnAnalysis.PivotTableConditionalFormattingScopeProperty.html)[] — A list of cell scopes for conditional formatting.

- `textFormat`: [IResolvable](/cdk/api/v2/docs/aws-cdk-lib.IResolvable.html) | [CfnAnalysis.TextConditionalFormatProperty](/cdk/api/v2/docs/aws-cdk-lib.aws_quicksight.CfnAnalysis.TextConditionalFormatProperty.html) — The text format of the cell for conditional formatting.