Operator Property (IColorConditionValue)

Gets or sets the format operator of condition value for color scale conditional format.
Property Operator As ConditionalFormatOperator
Dim instance As IColorConditionValue
Dim value As ConditionalFormatOperator
instance.Operator = value
value = instance.Operator
ConditionalFormatOperator Operator {get; set;}
To know more about customizing the color scale refer Value, Type properties. To check other types of conditional formatting types refer this link.
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.

Syncfusion.XlsIO.Base: 17.1460.0.47

See Also