# GC.Spread.Sheets.ConditionalFormatting.IconValueType

## Content

# Enumeration: IconValueType

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

Specifies the icon value type.

**`example`**
```
//This example creates a rule.
activeSheet.setValue(0,0,1,3);
activeSheet.setValue(1,0,15,3);
activeSheet.setValue(2,0,25,3);
activeSheet.setValue(3,0,-1,3);
var iconSetRule = new GC.Spread.Sheets.ConditionalFormatting.IconSetRule();
iconSetRule.ranges([new GC.Spread.Sheets.Range(0,0,4,1)]);
iconSetRule.iconSetType(GC.Spread.Sheets.ConditionalFormatting.IconSetType.fourTrafficLights);
var iconCriteria = iconSetRule.iconCriteria();
iconCriteria[0] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 1);
iconCriteria[1] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 10);
iconCriteria[2] = new GC.Spread.Sheets.ConditionalFormatting.IconCriterion(true, GC.Spread.Sheets.ConditionalFormatting.IconValueType.number, 20);
iconSetRule.reverseIconOrder(false);
iconSetRule.showIconOnly(false);
activeSheet.conditionalFormats.addRule(iconSetRule);
```

## Table of contents

### Enumeration members

- [formula](GC.Spread.Sheets.ConditionalFormatting.IconValueType#formula)
- [number](GC.Spread.Sheets.ConditionalFormatting.IconValueType#number)
- [percent](GC.Spread.Sheets.ConditionalFormatting.IconValueType#percent)
- [percentile](GC.Spread.Sheets.ConditionalFormatting.IconValueType#percentile)

## Enumeration members

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

• **formula** = `7`

Indicates whether to return the result of a formula calculation.

___

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

• **number** = `1`

Indicates whether to return a specified number directly.

___

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

• **percent** = `4`

Indicates whether to return the percentage of a cell value in a specified cell range.

___

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

• **percentile** = `5`

Indicates whether to return the percentile of a cell value in a specified cell range.