Syncfusion.XlsIO.Base
Example 


FormatColorRGB Property

Gets or sets the threshold of a color scale conditional format.
Syntax
'Declaration
 
Property FormatColorRGB As Color
'Usage
 
Dim instance As IColorConditionValue
Dim value As Color
 
instance.FormatColorRGB = value
 
value = instance.FormatColorRGB
Color FormatColorRGB {get; set;}
Remarks
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.
Example
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.
        workbook.SaveAs("ConditionalFormats.xlsx");
        workbook.Close();
        excelEngine.Dispose();
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also