FirstFormula Property (IConditionalFormat)

Gets or sets the value or expression associated with the conditional format.
Property FirstFormula As String
Dim instance As IConditionalFormat
Dim value As String
instance.FirstFormula = value
value = instance.FirstFormula
string FirstFormula {get; set;}
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.
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.

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also