FormatColorRGB Property

Gets or sets the threshold of a color scale conditional format.
Property FormatColorRGB As Color
Dim instance As IColorConditionValue
Dim value As Color
instance.FormatColorRGB = value
value = instance.FormatColorRGB
Color FormatColorRGB {get; set;}
The default color scale conditions can be customized by changing Type, Value and Operator Properties. To know more about advanced conditional formatting types refer this link.
The criteria for applying ColorScale can be accessed from the IColorScale.Criteria Property. Since the default size of the Criteria list is 2, In our example we access those two IColorConditionValue objects and set values for FormatColorRGB. Here we set each object a color and haven't mentioned any additional condition, So the default conditions will apply shades of these two colors depending on the values in the cells and set cell colors.
using Syncfusion.XlsIO;
using System.Drawing;
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 Color for FormatColorRGB Property.
        colorScale.Criteria[0].FormatColorRGB = Color.White;
        colorScale.Criteria[1].FormatColorRGB = Color.Red;
        //Save and Dispose.

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also