Gets or sets the minimum value. Note: The minimum value only accepts the ConditionalFormattingColorValue object which has a Type property value of Min, Number, Percent, Formula, or Pecentile.

Syntax

Visual Basic (Declaration)
Public Overridable Property MinValue As ConditionalFormattingColorValue

Visual Basic (Usage)	Copy Code
Dim instance As TwoColorScaleConditionalFormattingRule Dim value As ConditionalFormattingColorValue instance.MinValue = value value = instance.MinValue

C#
public virtual ConditionalFormattingColorValue MinValue {get; set;}

Example

This example uses the MinValue property.

C#	Copy Code
fpSpread1.Sheets[0].Cells[0, 0].Value = 3; fpSpread1.Sheets[0].Cells[1, 0].Value = 2; fpSpread1.Sheets[0].Cells[1, 1].Value = 10; fpSpread1.Sheets[0].Cells[0, 2].Value = 1; FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule two = new FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule(); two.MaxValue = new FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Red, 10, FarPoint.Win.Spread.ConditionalFormattingValueType.Max); two.MinValue = new FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Yellow, 2, FarPoint.Win.Spread.ConditionalFormattingValueType.Min); fpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, 3, 3, two);

Copy Code

fpSpread1.Sheets[0].Cells[0, 0].Value = 3;
fpSpread1.Sheets[0].Cells[1, 0].Value = 2;
fpSpread1.Sheets[0].Cells[1, 1].Value = 10;
fpSpread1.Sheets[0].Cells[0, 2].Value = 1;
FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule two = new FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule();
two.MaxValue = new FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Red, 10, FarPoint.Win.Spread.ConditionalFormattingValueType.Max);
two.MinValue = new FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Yellow, 2, FarPoint.Win.Spread.ConditionalFormattingValueType.Min);
fpSpread1.ActiveSheet.SetConditionalFormatting(0, 0, 3, 3, two);

VB.NET	Copy Code
FpSpread1.Sheets(0).Cells(0, 0).Value = 3 FpSpread1.Sheets(0).Cells(1, 0).Value = 2 FpSpread1.Sheets(0).Cells(1, 1).Value = 10 FpSpread1.Sheets(0).Cells(0, 2).Value = 1 Dim two As New FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule() two.MaxValue = New FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Red, 10, FarPoint.Win.Spread.ConditionalFormattingValueType.Max) two.MinValue = new FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Yellow, 2, FarPoint.Win.Spread.ConditionalFormattingValueType.Min) FpSpread1.Sheets(0).SetConditionalFormatting(0, 0, 3, 3, two)

VB.NET

Copy Code

FpSpread1.Sheets(0).Cells(0, 0).Value = 3
FpSpread1.Sheets(0).Cells(1, 0).Value = 2
FpSpread1.Sheets(0).Cells(1, 1).Value = 10
FpSpread1.Sheets(0).Cells(0, 2).Value = 1
Dim two As New FarPoint.Win.Spread.TwoColorScaleConditionalFormattingRule()
two.MaxValue = New FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Red, 10, FarPoint.Win.Spread.ConditionalFormattingValueType.Max)
two.MinValue = new FarPoint.Win.Spread.ConditionalFormattingColorValue(Color.Yellow, 2, FarPoint.Win.Spread.ConditionalFormattingValueType.Min)
FpSpread1.Sheets(0).SetConditionalFormatting(0, 0, 3, 3, two)

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Syntax

Example

Requirements

See Also

Reference

Spread Windows Forms 7.0 Product Documentation
MinValue Property
See Also Example Support Options