FormatConditionRangeSetPredefinedType Enum

Lists predefined styles used to apply conditional formatting using value ranges.

Declaration

export enum FormatConditionRangeSetPredefinedType {
    None = 0,
    Custom = 1,
    Arrows2 = 2,
    Arrows3 = 3,
    Arrows4 = 4,
    Arrows5 = 5,
    ArrowsGray2 = 6,
    ArrowsGray3 = 7,
    ArrowsGray4 = 8,
    ArrowsGray5 = 9,
    PositiveNegative3 = 10,
    Stars3 = 11,
    Quarters5 = 12,
    Bars4 = 13,
    Bars5 = 14,
    Boxes5 = 15,
    TrafficLights3 = 16,
    Circles2 = 17,
    Circles3 = 18,
    Circles4 = 19,
    CirclesRedToBlack4 = 20,
    Signs3 = 21,
    Symbols2 = 22,
    Symbols3 = 23,
    SymbolsCircled2 = 24,
    SymbolsCircled3 = 25,
    Flags3 = 26,
    ColorsPaleRedGreen = 27,
    ColorsPaleRedGreenBlue = 28,
    ColorsPaleRedYellowGreenBlue = 29,
    ColorsPaleRedOrangeYellowGreenBlue = 30,
    ColorsRedGreen = 31,
    ColorsRedGreenBlue = 32,
    ColorsRedYellowGreenBlue = 33,
    ColorsRedOrangeYellowGreenBlue = 34
}

Members

Name
Arrows2
Arrows3
Arrows4
Arrows5
ArrowsGray2
ArrowsGray3
ArrowsGray4
ArrowsGray5
Bars4
Bars5
Boxes5
Circles2
Circles3
Circles4
CirclesRedToBlack4
ColorsPaleRedGreen
ColorsPaleRedGreenBlue
ColorsPaleRedOrangeYellowGreenBlue
ColorsPaleRedYellowGreenBlue
ColorsRedGreen
ColorsRedGreenBlue
ColorsRedOrangeYellowGreenBlue
ColorsRedYellowGreenBlue
Custom
Flags3
None
PositiveNegative3
Quarters5
Signs3
Stars3
Symbols2
Symbols3
SymbolsCircled2
SymbolsCircled3
TrafficLights3

Remarks

To use a predefined set of colors/icons in a range condition, pass the required FormatConditionRangeSetPredefinedType enumeration value to the FormatConditionRangeSet constructor and assign the resulting FormatConditionRangeSet object to the DashboardItemFormatRule.condition property.