Syncfusion.XlsIO.Base
Example 


FirstFormula Property (IConditionalFormat)

Gets or sets the value or expression associated with the conditional format.
Syntax
'Declaration
 
Property FirstFormula As String
'Usage
 
Dim instance As IConditionalFormat
Dim value As String
 
instance.FirstFormula = value
 
value = instance.FirstFormula
string FirstFormula {get; set;}
Remarks
Relative cell addresses can be used to apply formatting by using FirstFormulaR1C1 and SecondFormulaR1C1. To know more about R1C1 notation refer Using FormulaR1C1 property in Conditional Formats.
Example
FirstFormula property is used to set value that is used for setting conditions. ExcelCFType.CellValue applies conditional formatting based on the condition from ExcelComparisonOperator enumeration. This requires atleast one value to apply conditional format. Here for example, we set "60" to FirstFormula property.
using Syncfusion.XlsIO;
            
class Example
{
    static void Main()
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create a worksheet.        
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet worksheet = workbook.Worksheets[0];
            
            //Load data to Apply Conditional Formatting.
            worksheet["B1"].Text = "Conditional Formats";
            worksheet["B2"].Number = 10;
            worksheet["B3"].Number = 20;
            worksheet["B4"].Number = 30;
            worksheet["B5"].Number = 40;
            worksheet["B6"].Number = 50;
            worksheet["B7"].Number = 60;
            worksheet["B8"].Number = 70;
            worksheet["B9"].Number = 80;
            worksheet["B10"].Number = 90;
            worksheet["B11"].Number = 100;
            
            //Create instance of IConditonalFormat and IConditionalFormats.
            IConditionalFormats formats = worksheet["B2:B11"].ConditionalFormats;
            IConditionalFormat format = formats.AddCondition();
            
            //Set Condition.
            format.FirstFormula = "60";
            format.SecondFormula = "20";
            format.Operator = ExcelComparisonOperator.Between;
            
            //Apply Conditional format.
            format.BottomBorderStyle = ExcelLineStyle.Thick;
            format.LeftBorderStyle = ExcelLineStyle.Thick;
            format.TopBorderStyle = ExcelLineStyle.Thick;
            format.RightBorderStyle = ExcelLineStyle.Thick;
                
            //Set Border color.
            format.BottomBorderColor = ExcelKnownColors.Red;
            format.LeftBorderColor = ExcelKnownColors.Red;
            format.TopBorderColor = ExcelKnownColors.Red;
            format.RightBorderColor = ExcelKnownColors.Red;
            
            //Save and Dispose.
            workbook.SaveAs("ConditionalFormats.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also