FormatConditionAppearanceType Type

Lists values used to specify style settings used in conditional formatting.

Declaration

export type FormatConditionAppearanceType = 'None' | 'Custom' | 'PaleRed' | 'PaleYellow' | 'PaleGreen' | 'PaleBlue' | 'PalePurple' | 'PaleCyan' | 'PaleOrange' | 'PaleGray' | 'Red' | 'Yellow' | 'Green' | 'Blue' | 'Purple' | 'Cyan' | 'Orange' | 'Gray' | 'GradientRed' | 'GradientYellow' | 'GradientGreen' | 'GradientBlue' | 'GradientPurple' | 'GradientCyan' | 'GradientOrange' | 'GradientTransparent' | 'FontBold' | 'FontItalic' | 'FontUnderline' | 'FontGrayed' | 'FontRed' | 'FontYellow' | 'FontGreen' | 'FontBlue'

Members

Name Description
"None"

Style settings are not changed.

"Custom"

A custom appearance. If the AppearanceSettings.appearanceType is set to Custom, use the AppearanceSettings.backColor, AppearanceSettings.ForeColor, AppearanceSettings.fontFamily, and AppearanceSettings.fontStyle properties to specify appearance settings.

"PaleRed"

The Pale Red color.

"PaleYellow"

The Pale Yellow color.

"PaleGreen"

The Pale Green color.

"PaleBlue"

The Pale Blue color.

"PalePurple"

The Pale Purple color.

"PaleCyan"

The Pale Cyan color.

"PaleOrange"

The Pale Orange color.

"PaleGray"

The Pale Gray color.

"Red"

The Pale Orange color.

"Yellow"

The Yellow color.

"Green"

The Green color.

"Blue"

The Blue color.

"Purple"

The Purple color.

"Cyan"

The Cyan color.

"Orange"

The Orange color.

"Gray"

The Gray color.

"GradientRed"

The Red color used in gradient ranges.

"GradientYellow"

The Yellow color used in gradient ranges.

"GradientGreen"

The Green color used in gradient ranges.

"GradientBlue"

The Blue color used in gradient ranges.

"GradientPurple"

The Purple color used in gradient ranges.

"GradientCyan"

The Cyan color used in gradient ranges.

"GradientOrange"

The Orange color used in gradient ranges.

"GradientTransparent"

The transparent color used in gradient ranges.

"FontBold"

The bold font.

"FontItalic"

The Italic font.

"FontUnderline"

The underline font.

"FontGrayed"

The Gray font.

"FontRed"

The Red font.

"FontYellow"

The Yellow font.

"FontGreen"

The Green font.

"FontBlue"

The Blue font.

Remarks

Values listed in this type alias are used to set the following properties: