ThreeColorScaleConditionalFormattingRule Constructor(ConditionalFormattingColorValue,ConditionalFormattingColorValue,ConditionalFormattingColorValue)

In This Topic

Initializes a new instance of the ThreeColorScaleConditionalFormattingRule class.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal minValue As ConditionalFormattingColorValue, _
   ByVal midValue As ConditionalFormattingColorValue, _
   ByVal maxValue As ConditionalFormattingColorValue _
)

'Usage
 
Dim minValue As ConditionalFormattingColorValue
Dim midValue As ConditionalFormattingColorValue
Dim maxValue As ConditionalFormattingColorValue
 
Dim instance As New ThreeColorScaleConditionalFormattingRule(minValue, midValue, maxValue)

public ThreeColorScaleConditionalFormattingRule( 
   ConditionalFormattingColorValue minValue,
   ConditionalFormattingColorValue midValue,
   ConditionalFormattingColorValue maxValue
)

Parameters

minValue: The minimum value. Note: The minimum value only accepts the ConditionalFormattingColorValue object which has a Type value of Min, Number, Percent, Formula, or Pecentile.
midValue: The middle value. Note: The middle value only accepts the ConditionalFormattingColorValue object which has a Type value of Number, Percent, Formula, or Pecentile.
maxValue: The maximum value. Note: The maximum value only accepts the ConditionalFormattingColorValue object which has a Type value of Max, Number, Percent, Formula, or Pecentile.

Example

This example creates a color rule.

C#
Visual Basic

Reference

ThreeColorScaleConditionalFormattingRule Class
ThreeColorScaleConditionalFormattingRule Members
Overload List