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


In This Topic
    ConditionalFormatting Class
    In This Topic
    Contains the methods shared by all available types of conditional formatting.
    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

    Requirements

    Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also

    Reference

    ConditionalFormatting Members
    Xceed.Workbooks.NET Namespace

    Send Feedback