# GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators

## Content

# Enumeration: ComparisonOperators

[Sheets](../modules/GC.Spread.Sheets).[ConditionalFormatting](../modules/GC.Spread.Sheets.ConditionalFormatting).ComparisonOperators

Specifies the comparison operator.

**`example`**
```
spread.options.highlightInvalidData = true;
var dv = GC.Spread.Sheets.DataValidation.createDateValidator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.between, new Date(2012, 11, 31), new Date(2013, 11, 31));
dv.showInputMessage(true);
dv.inputMessage("Enter a date between 12/31/2012 and 12/31/2013.");
dv.inputTitle("Tip");
activeSheet.getCell(1, -1).validator(dv);
```

## Table of contents

### Enumeration members

- [between](GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators#between)
- [equalsTo](GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators#equalsto)
- [greaterThan](GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators#greaterthan)
- [greaterThanOrEqualsTo](GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators#greaterthanorequalsto)
- [lessThan](GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators#lessthan)
- [lessThanOrEqualsTo](GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators#lessthanorequalsto)
- [notBetween](GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators#notbetween)
- [notEqualsTo](GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators#notequalsto)

## Enumeration members

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

• **between** = `6`

Determines whether a cell value is between the two parameter values.

___

### <a id="equalsto" name="equalsto"></a> equalsTo

• **equalsTo** = `0`

Determines whether a cell value is equal to the parameter value.

___

### <a id="greaterthan" name="greaterthan"></a> greaterThan

• **greaterThan** = `2`

Determines whether a cell value is greater than the parameter value.

___

### <a id="greaterthanorequalsto" name="greaterthanorequalsto"></a> greaterThanOrEqualsTo

• **greaterThanOrEqualsTo** = `3`

Determines whether a cell value is greater than or equal to the parameter value.

___

### <a id="lessthan" name="lessthan"></a> lessThan

• **lessThan** = `4`

Determines whether a cell value is less than the parameter value.

___

### <a id="lessthanorequalsto" name="lessthanorequalsto"></a> lessThanOrEqualsTo

• **lessThanOrEqualsTo** = `5`

Determines whether a cell value is less than or equal to the parameter value.

___

### <a id="notbetween" name="notbetween"></a> notBetween

• **notBetween** = `7`

Determines whether a cell value is not between the two parameter values.

___

### <a id="notequalsto" name="notequalsto"></a> notEqualsTo

• **notEqualsTo** = `1`

Determines whether a cell value is not equal to the parameter value.