Click or drag to resize

ExcelConditionalFormatsCollectionAddColorScale(Color, Color, Color) Method

Adds a three color scale: the cell with the lowest value gets the minimum color, the cells at the 50th percentile get the midpoint color, the cell with the highest value gets the maximum color and the other cells get a color in between.

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntax
public ExcelConditionalFormat AddColorScale(
	Color minimumColor,
	Color midpointColor,
	Color maximumColor
)

Parameters

minimumColor  Color
The color of the lowest value.
midpointColor  Color
The color of the 50th percentile.
maximumColor  Color
The color of the highest value.

Return Value

ExcelConditionalFormat
The new conditional format rule.
See Also