Syncfusion.XlsIO.Base
Example 


Operator Property (IColorConditionValue)

Gets or sets the format operator of condition value for color scale conditional format.
Syntax
'Declaration
 
Property Operator As ConditionalFormatOperator
'Usage
 
Dim instance As IColorConditionValue
Dim value As ConditionalFormatOperator
 
instance.Operator = value
 
value = instance.Operator
ConditionalFormatOperator Operator {get; set;}
Remarks
To know more about customizing the color scale refer Value, Type properties. To check other types of conditional formatting types refer this link.
Example
By default the Operator property is set to ConditionalFormatOperator.GreaterThanorEqualTo, This will set color scale to the cells above the specified threshold value starting from it. ConditionalFormatOperator.GreaterThan can be used to change the color scale to set colors above the specified threshold value.
using Syncfusion.XlsIO;
            
class Example
{
    static void Main()
    {
        //Create a worksheet.        
        ExcelEngine excelEngine = new ExcelEngine();
        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["A1"].Text = "ColorScale";
        worksheet["A2"].Number  =  10;
        worksheet["A3"].Number  =  20;
        worksheet["A4"].Number  =  30;
        worksheet["A5"].Number  =  40;
        worksheet["A6"].Number  =  50;
        worksheet["A7"].Number  =  60;
        worksheet["A8"].Number  =  70;
        worksheet["A9"].Number  =  80;
        worksheet["A10"].Number =  90;
        worksheet["A11"].Number =  100;
        
        //Create instance of IConditonalFormat and IConditionalFormats.
        IConditionalFormats formats = worksheet["A2:A11"].ConditionalFormats;
        IConditionalFormat format = formats.AddCondition();
            
        //Set FormatType as ColorScale.
        format.FormatType = ExcelCFType.ColorScale;
        IColorScale colorScale = format.ColorScale;
        
        //Set threshold value and type
        colorScale.Criteria[0].Value = "70";
        colorScale.Criteria[0].Type = ConditionValueType.Percent;        
        
        //Set operator to GreaterThan
        colorScale.Criteria[0].Operator = ConditionalFormatOperator.GreaterThan;
            
        //Save and Dispose.
        workbook.SaveAs("ConditionalFormats.xlsx");
        workbook.Close();
        excelEngine.Dispose();
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.47

See Also