Spread ASP.NET 17
Spread for ASP.NET 17 Product Documentation / Developer's Guide / Customizing User Interaction / Customizing Interaction with Cells / Using Conditional Formatting in Cells / Creating Conditional Formatting with Rules / Highlighting Rules
In This Topic
    Highlighting Rules
    In This Topic

    You can use this rule to highlight data that meets one of the following conditions:

    After you choose one of the options above, enter a value or formula against which each cell is compared. If the cell data satisfies that criteria, then the formatting is applied.

    You can select a predefined highlight style or create a custom highlight style. The following rules are highlight style rules:

    Using Code

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

    Example

    This example code creates the between values 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 = 5;
           FpSpread1.Sheets[0].Cells[0, 2].Value = 1;
       }

    protected void Button1_Click(object sender, EventArgs e)
            {
                FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule between = new FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule(false);
                between.FirstValue = 10;
                between.SecondValue = 20;
                between.IsNotBetween = true;
                between.BackColor = Color.Bisque;
                FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, between);
            }

    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 = 5
                FpSpread1.Sheets(0).Cells(0, 2).Value = 1
            End Sub

    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
                Dim between As New FarPoint.Web.Spread.BetweenValuesConditionalFormattingRule(False)
                between.FirstValue = 10
                between.SecondValue = 20
                between.IsNotBetween = True
                between.BackColor = Drawing.Color.Bisque
                FpSpread1.ActiveSheetView.SetConditionalFormatting(1, 1, between)
            End Sub

    Using the Spread Designer

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