# GC.Spread.Sheets.ConditionalFormatting.CustomValueType

## Content

# Enumeration: CustomValueType

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

Specifies the custom value type.

**`example`**
```javascript
var nCondition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.formulaCondition, {compareType: GC.Spread.Sheets.ConditionalFormatting.CustomValueType.nonEmpty});
var validator = new GC.Spread.Sheets.DataValidation.DefaultDataValidator(nCondition);
validator.ignoreBlank(false);
activeSheet.getCell(0, 0, GC.Spread.Sheets.SheetArea.viewport).validator(validator);
spread.options.highlightInvalidData = true;
```

## Table of contents

### Enumeration members

- [empty](GC.Spread.Sheets.ConditionalFormatting.CustomValueType#empty)
- [error](GC.Spread.Sheets.ConditionalFormatting.CustomValueType#error)
- [formula](GC.Spread.Sheets.ConditionalFormatting.CustomValueType#formula)
- [nonEmpty](GC.Spread.Sheets.ConditionalFormatting.CustomValueType#nonempty)
- [nonError](GC.Spread.Sheets.ConditionalFormatting.CustomValueType#nonerror)

## Enumeration members

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

• **empty** = `0`

Indicates whether the cell value is empty or null.

___

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

• **error** = `2`

Indicates whether the cell value contains a calculation error.

___

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

• **formula** = `4`

Indicates whether the cell value is a formula.

___

### <a id="nonempty" name="nonempty"></a> nonEmpty

• **nonEmpty** = `1`

Indicates whether the cell value is not empty or null.

___

### <a id="nonerror" name="nonerror"></a> nonError

• **nonError** = `3`

Indicates whether the cell value does not contain a calculation error.