'Declaration
 
Public Function AddTwoScaleRule( _
   ByVal minType As ScaleValueType, _
   ByVal minValue As Object, _
   ByVal minColor As Color, _
   ByVal maxType As ScaleValueType, _
   ByVal maxValue As Object, _
   ByVal maxColor As Color, _
   ByVal ParamArray ranges() As CellRange _
) As TwoColorScaleRule

'Usage
 
Dim instance As ConditionalFormat
Dim minType As ScaleValueType
Dim minValue As Object
Dim minColor As Color
Dim maxType As ScaleValueType
Dim maxValue As Object
Dim maxColor As Color
Dim ranges() As CellRange
Dim value As TwoColorScaleRule
 
value = instance.AddTwoScaleRule(minType, minValue, minColor, maxType, maxValue, maxColor, ranges)

public TwoColorScaleRule AddTwoScaleRule( 
   ScaleValueType minType,
   object minValue,
   Color minColor,
   ScaleValueType maxType,
   object maxValue,
   Color maxColor,
   params CellRange[] ranges
)

Parameters

minType

The minimum scale type.

minValue

The minimum scale value.

minColor

The minimum scale color.

maxType

The maximum scale type.

maxValue

The maximum scale value.

maxColor

The maximum scale color.

ranges

The cell ranges where the rule is applied.

Return Value

Reference

ConditionalFormat Class
ConditionalFormat Members