# GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition

## Content

# Interface: IConditionTemplateDefinition

[Sheets](../modules/GC.Spread.Sheets).[NamedCellTemplates](../modules/GC.Spread.Sheets.NamedCellTemplates).IConditionTemplateDefinition

## Table of contents

### Properties

- [compareType](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#comparetype)
- [conType](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#contype)
- [customValueType](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#customvaluetype)
- [expectTypeId](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#expecttypeid)
- [expected](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#expected)
- [forceValue2Text](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#forcevalue2text)
- [formula](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#formula)
- [ignoreBlank](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#ignoreblank)
- [ignoreCase](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#ignorecase)
- [integerValue](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#integervalue)
- [isPercent](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#ispercent)
- [item1](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#item1)
- [item2](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#item2)
- [preciseCompareDate](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#precisecomparedate)
- [regex](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#regex)
- [treatNullValueAsZero](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#treatnullvalueaszero)
- [type](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#type)
- [useWildCards](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition#usewildcards)

## Properties

### <a id="comparetype" name="comparetype"></a> compareType

• `Optional` **compareType**: [`LogicalOperators`](../enums/GC.Spread.Sheets.ConditionalFormatting.LogicalOperators) \| [`GeneralComparisonOperators`](../enums/GC.Spread.Sheets.ConditionalFormatting.GeneralComparisonOperators) \| [`TextCompareType`](../enums/GC.Spread.Sheets.ConditionalFormatting.TextCompareType) \| [`ColorCompareType`](../enums/GC.Spread.Sheets.ConditionalFormatting.ColorCompareType) \| [`DateCompareType`](../enums/GC.Spread.Sheets.ConditionalFormatting.DateCompareType) \| [`ComparisonOperators`](../enums/GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators)

___

### <a id="contype" name="contype"></a> conType

• `Optional` **conType**: [`ConditionType`](../enums/GC.Spread.Sheets.ConditionalFormatting.ConditionType)

___

### <a id="customvaluetype" name="customvaluetype"></a> customValueType

• `Optional` **customValueType**: [`CustomValueType`](../enums/GC.Spread.Sheets.ConditionalFormatting.CustomValueType)

___

### <a id="expecttypeid" name="expecttypeid"></a> expectTypeId

• `Optional` **expectTypeId**: `number`

___

### <a id="expected" name="expected"></a> expected

• `Optional` **expected**: `any`

___

### <a id="forcevalue2text" name="forcevalue2text"></a> forceValue2Text

• `Optional` **forceValue2Text**: `boolean`

___

### <a id="formula" name="formula"></a> formula

• `Optional` **formula**: `string`

___

### <a id="ignoreblank" name="ignoreblank"></a> ignoreBlank

• `Optional` **ignoreBlank**: `boolean`

___

### <a id="ignorecase" name="ignorecase"></a> ignoreCase

• `Optional` **ignoreCase**: `boolean`

___

### <a id="integervalue" name="integervalue"></a> integerValue

• `Optional` **integerValue**: `boolean`

___

### <a id="ispercent" name="ispercent"></a> isPercent

• `Optional` **isPercent**: `boolean`

___

### <a id="item1" name="item1"></a> item1

• `Optional` **item1**: [`IConditionTemplateDefinition`](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition)

___

### <a id="item2" name="item2"></a> item2

• `Optional` **item2**: [`IConditionTemplateDefinition`](GC.Spread.Sheets.NamedCellTemplates.IConditionTemplateDefinition)

___

### <a id="precisecomparedate" name="precisecomparedate"></a> preciseCompareDate

• `Optional` **preciseCompareDate**: `boolean`

___

### <a id="regex" name="regex"></a> regex

• `Optional` **regex**: `string`

___

### <a id="treatnullvalueaszero" name="treatnullvalueaszero"></a> treatNullValueAsZero

• `Optional` **treatNullValueAsZero**: `boolean`

___

### <a id="type" name="type"></a> type

• `Optional` **type**: [`AverageConditionType`](../enums/GC.Spread.Sheets.ConditionalFormatting.AverageConditionType) \| [`DateOccurringType`](../enums/GC.Spread.Sheets.ConditionalFormatting.DateOccurringType) \| [`Top10ConditionType`](../enums/GC.Spread.Sheets.ConditionalFormatting.Top10ConditionType)

___

### <a id="usewildcards" name="usewildcards"></a> useWildCards

• `Optional` **useWildCards**: `boolean`