Top or Average Rules

In This Topic

The top or bottom rules apply formatting to cells whose values fall in the top or bottom percent. The top ranked rule specifies the top or bottom values. The average rule applies to the greater or lesser average value of the entire range.

The following options are available:

top 10
top 10%
bottom 10
bottom 10%
above average
below average

Using Code

Set the properties of the rule class and then apply the formatting.

Example

This example code creates an average rule and uses the SetConditionalFormatting method to apply the rule.

C#	Copy Code
protected void Page_Load(object sender, System.EventArgs e) { 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; } protected void Button1_Click(object sender, EventArgs e) { //Average CF FarPoint.Web.Spread.AverageConditionalFormattingRule average = new FarPoint.Web.Spread.AverageConditionalFormattingRule(true, true); average.IsAbove = true; average.IsIncludeEquals = true; average.StandardDeviation = 5; average.FontStyle = new FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None); average.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold; FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, average); }

Copy Code

protected void Page_Load(object sender, System.EventArgs e)
{
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;
}

protected void Button1_Click(object sender, EventArgs e)
{
//Average CF
FarPoint.Web.Spread.AverageConditionalFormattingRule average = new FarPoint.Web.Spread.AverageConditionalFormattingRule(true, true);
average.IsAbove = true;
average.IsIncludeEquals = true;
average.StandardDeviation = 5;
average.FontStyle = new FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None);
average.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold;
FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, average);
}

VB	Copy Code
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 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 End Sub Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click 'Average CF Dim average As New FarPoint.Web.Spread.AverageConditionalFormattingRule(True, True) average.IsAbove = True average.IsIncludeEquals = True average.StandardDeviation = 5 average.FontStyle = New FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None) average.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, average) End Sub

Copy Code

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
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
End Sub

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
'Average CF
Dim average As New FarPoint.Web.Spread.AverageConditionalFormattingRule(True, True)
average.IsAbove = True
average.IsIncludeEquals = True
average.StandardDeviation = 5
average.FontStyle = New FarPoint.Web.Spread.SpreadFontStyle(FarPoint.Web.Spread.UnderlineFontStyle.None)
average.FontStyle.RegularBoldItalic = FarPoint.Web.Spread.RegularBoldItalicFontStyle.Bold
FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, average)
End Sub

Using the Spread Designer

In the work area, select the cell or cells for which you want to set the conditional format.
Under the Home menu, select the Conditional Formatting icon in the Style section, then select the Top Bottom Rules option, and then choose the condition.
From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.