# GC.Spread.Sheets.ConditionalFormatting.ScaleValueType

## Content

# Enumeration: ScaleValueType

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

Specifies the scale value type.

**`example`**
```
//This example creates a data bar 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 dataBarRule = new GC.Spread.Sheets.ConditionalFormatting.DataBarRule();
dataBarRule.ranges([new GC.Spread.Sheets.Range(0,0,4,1)]);
dataBarRule.minType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number);
dataBarRule.minValue(-1);
dataBarRule.maxType(GC.Spread.Sheets.ConditionalFormatting.ScaleValueType.number);
dataBarRule.maxValue(40);
dataBarRule.color("green");
dataBarRule.showBorder(true);
dataBarRule.borderColor("orange");
dataBarRule.dataBarDirection(GC.Spread.Sheets.ConditionalFormatting.BarDirection.leftToRight);
dataBarRule.negativeFillColor("yellow");
dataBarRule.useNegativeFillColor(true);
dataBarRule.negativeBorderColor("red");
dataBarRule.useNegativeBorderColor(true);
dataBarRule.axisPosition(GC.Spread.Sheets.ConditionalFormatting.DataBarAxisPosition.automatic);
dataBarRule.axisColor("blue");
dataBarRule.showBarOnly(false);
activeSheet.conditionalFormats.addRule(dataBarRule);
```

## Table of contents

### Enumeration members

- [automax](GC.Spread.Sheets.ConditionalFormatting.ScaleValueType#automax)
- [automin](GC.Spread.Sheets.ConditionalFormatting.ScaleValueType#automin)
- [formula](GC.Spread.Sheets.ConditionalFormatting.ScaleValueType#formula)
- [highestValue](GC.Spread.Sheets.ConditionalFormatting.ScaleValueType#highestvalue)
- [lowestValue](GC.Spread.Sheets.ConditionalFormatting.ScaleValueType#lowestvalue)
- [number](GC.Spread.Sheets.ConditionalFormatting.ScaleValueType#number)
- [percent](GC.Spread.Sheets.ConditionalFormatting.ScaleValueType#percent)
- [percentile](GC.Spread.Sheets.ConditionalFormatting.ScaleValueType#percentile)

## Enumeration members

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

• **automax** = `7`

Indicates whether to return the automatic maximum value in a specified range.

___

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

• **automin** = `5`

Indicates whether to return the automatic minimum value in a specified range.

___

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

• **formula** = `6`

Indicates whether to return the result of a formula calculation.

___

### <a id="highestvalue" name="highestvalue"></a> highestValue

• **highestValue** = `2`

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

___

### <a id="lowestvalue" name="lowestvalue"></a> lowestValue

• **lowestValue** = `1`

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

___

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

• **number** = `0`

Indicates whether to return a specified number directly.

___

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

• **percent** = `3`

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

___

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

• **percentile** = `4`

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