'Declaration
Public MustInherit Class ConditionalFormatting
'Usage
Dim instance As ConditionalFormatting
public abstract class ConditionalFormatting
'Declaration
Public MustInherit Class ConditionalFormatting
'Usage
Dim instance As ConditionalFormatting
public abstract class ConditionalFormatting
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.
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);
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
Name | Description | |
---|---|---|
![]() | AddArea | Overloaded. Adds ConditionalFomatting in a specific area of the Worksheet. |
![]() | AddAreas | Adds ConditionalFormatting in specific areas of the Worksheet. |
![]() | ClearAreas | Removes all ConditionalFormattings from the Worksheet. |
![]() ![]() | CreateAboveAverage | Creates an AboveAverage ConditionalFormatting. |
![]() ![]() | CreateCellHighlight | Creates a Highlight Cells ConditionalFormatting. |
![]() ![]() | CreateColorScale | Creates a Color Scales ConditionalFormatting. |
![]() ![]() | CreateColorScaleCustom | Creates a custom Color Scales ConditionFormatting. |
![]() ![]() | CreateDataBar | Overloaded. Creates a Data Bar ConditionnalFormatting. |
![]() ![]() | CreateIconSet | Creates in Icon Set ConditionalFormatting. |
![]() ![]() | CreateTop10 | Creates a Top 10 ConditionalFormatting. |
![]() | GetAreas | Gets the areas using ConditionalFormatting. |
![]() | RemoveArea | Overloaded. Removes ConditionalFormatting from a specific area of the Worksheet. |
![]() | RemoveAreas | Removes ConditionalFormatting from specific areas of the Worksheet. |
![]() | SetCustomStyle | Sets a custom Style for the ConditionalFormatting. |
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