Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / ConditionalFormatting Class
Example


In This Topic
    ConditionalFormatting Class
    In This Topic
    Contains the methods shared by all available types of conditional formatting.
    Object Model
    ConditionalFormatting ClassConditionalFormatting ClassConditionalFormatting ClassConditionalFormatting ClassConditionalFormattingAboveAverage ClassConditionalFormattingCellHighlight ClassConditionalFormattingColorScale ClassConditionalFormattingColorScale ClassConditionalFormattingDataBar ClassConditionalFormattingIconSet ClassConditionalFormattingTop10 ClassConditionalFormatting ClassConditionalFormatting ClassConditionalFormatting Class
    Syntax
    'Declaration
 

    Public MustInherit Class ConditionalFormatting 
    'Usage
 

    Dim instance As ConditionalFormatting
    public abstract class ConditionalFormatting
    Remarks

    Xceed supports various types of conditional formattings, like AboveAverage, CellHighlight & Top10.

    All of those will use a different rule to determine which Cells needs to be formatted.

    Example
    ConditionalFormatting cf = new ConditionalFormattingTop10();
cf.AddAreas( "A1:A2", "B1:B2", "C1:C2" );
cf.RemoveAreas( "B1:B2" );
string[] result = cf.GetAreas(); 
// Only A1:A2 and C1:C2 are left.

//Adds the ConditionalFormatting on the chosen Worksheet. 
doc.Worksheets[ 0 ].ConditionalFormattings.Add(cf);
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.ConditionalFormatting
          Xceed.Workbooks.NET.ConditionalFormattingAboveAverage
          Xceed.Workbooks.NET.ConditionalFormattingCellHighlight
          Xceed.Workbooks.NET.ConditionalFormattingColorScale
          Xceed.Workbooks.NET.ConditionalFormattingDataBar
          Xceed.Workbooks.NET.ConditionalFormattingIconSet
          Xceed.Workbooks.NET.ConditionalFormattingTop10

    Public Methods
     NameDescription
    Public MethodAddAreaOverloaded. Adds ConditionalFomatting in a specific area of the Worksheet.  
    Public MethodAddAreasAdds ConditionalFormatting in specific areas of the Worksheet.  
    Public MethodClearAreasRemoves all ConditionalFormattings from the Worksheet.  
    Public Methodstatic (Shared in Visual Basic)CreateAboveAverageCreates an AboveAverage ConditionalFormatting.  
    Public Methodstatic (Shared in Visual Basic)CreateCellHighlightCreates a Highlight Cells ConditionalFormatting.  
    Public Methodstatic (Shared in Visual Basic)CreateColorScaleCreates a Color Scales ConditionalFormatting.  
    Public Methodstatic (Shared in Visual Basic)CreateColorScaleCustomCreates a custom Color Scales ConditionFormatting.  
    Public Methodstatic (Shared in Visual Basic)CreateDataBarOverloaded. Creates a Data Bar ConditionnalFormatting.   
    Public Methodstatic (Shared in Visual Basic)CreateIconSetCreates in Icon Set ConditionalFormatting.  
    Public Methodstatic (Shared in Visual Basic)CreateTop10Creates a Top 10 ConditionalFormatting.  
    Public MethodGetAreasGets the areas using ConditionalFormatting.  
    Public MethodRemoveAreaOverloaded. Removes ConditionalFormatting from a specific area of the Worksheet.  
    Public MethodRemoveAreasRemoves ConditionalFormatting from specific areas of the Worksheet.  
    Public MethodSetCustomStyleSets a custom Style for the ConditionalFormatting.  
    Top
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    ConditionalFormatting Members
    Xceed.Workbooks.NET Namespace

    Send Feedback