FormatConditionRangeGradientPredefinedType Enum

Lists predefined color gradients used to apply conditional formatting using value ranges.

Declaration

export enum FormatConditionRangeGradientPredefinedType {
    None = 0,
    Custom = 1,
    GreenWhite = 2,
    WhiteGreen = 3,
    RedWhite = 4,
    WhiteRed = 5,
    YellowGreen = 6,
    GreenYellow = 7,
    YellowRed = 8,
    RedYellow = 9,
    BlueWhite = 10,
    WhiteBlue = 11,
    BlueRed = 12,
    RedBlue = 13,
    YellowBlue = 14,
    BlueYellow = 15,
    GreenBlue = 16,
    BlueGreen = 17,
    GreenWhiteBlue = 18,
    BlueWhiteGreen = 19,
    BlueWhiteRed = 20,
    RedWhiteBlue = 21,
    GreenWhiteRed = 22,
    RedWhiteGreen = 23,
    GreenYellowRed = 24,
    RedYellowGreen = 25,
    BlueYellowRed = 26,
    RedYellowBlue = 27,
    GreenYellowBlue = 28,
    BlueYellowGreen = 29
}

Members

Name
BlueGreen
BlueRed
BlueWhite
BlueWhiteGreen
BlueWhiteRed
BlueYellow
BlueYellowGreen
BlueYellowRed
Custom
GreenBlue
GreenWhite
GreenWhiteBlue
GreenWhiteRed
GreenYellow
GreenYellowBlue
GreenYellowRed
None
RedBlue
RedWhite
RedWhiteBlue
RedWhiteGreen
RedYellow
RedYellowBlue
RedYellowGreen
WhiteBlue
WhiteGreen
WhiteRed
YellowBlue
YellowGreen
YellowRed

Remarks

To use a predefined set of start/end colors to create a color gradient, pass the required FormatConditionRangeGradientPredefinedType enumeration value to the FormatConditionRangeGradient constructor.