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.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic ExcelConditionalFormat AddColorScale(
Color minimumColor,
Color midpointColor,
Color maximumColor
)
Public Function AddColorScale (
minimumColor As Color,
midpointColor As Color,
maximumColor As Color
) As ExcelConditionalFormat
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
ExcelConditionalFormatThe new conditional format rule.
See Also