API Reference
Class
ExcelRangeConditionalFormattingBuilder
Fluent conditional formatting builder for an ExcelRange.
Inheritance
- Object
- ExcelRangeConditionalFormattingBuilder
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
- Property ExcelRange.ConditionalFormat
- Property ExcelRange.ConditionalFormatting
Methods
AboveAverage 3 overloads
public ExcelRange AboveAverage(Boolean equalAverage = false, Nullable<UInt32> standardDeviation = null) #Returns:
ExcelRangeApplies an above-average rule with an optional solid fill.
Parameters
- fillColor System.String = false
- equalAverage System.Boolean = null
AboveAverage(System.Boolean equalAverage, System.Nullable{System.UInt32} standardDeviation) #Applies an above-average rule.
Parameters
- equalAverage System.Boolean
- standardDeviation System.Nullable{System.UInt32}
public ExcelRange BeginsWith(String text) #Returns:
ExcelRangeApplies a begins-with text rule.
Parameters
- text System.String
BeginsWithText 2 overloads
public ExcelRange BeginsWithText(String text) #Returns:
ExcelRangeApplies a begins-with-text rule.
Parameters
- text System.String
public ExcelRange BeginsWithText(String text, String fillColor) #Returns:
ExcelRangeApplies a begins-with-text rule with an optional solid fill.
Parameters
- text System.String
- fillColor System.String
BelowAverage 3 overloads
public ExcelRange BelowAverage(Boolean equalAverage = false, Nullable<UInt32> standardDeviation = null) #Returns:
ExcelRangeApplies a below-average rule with an optional solid fill.
Parameters
- fillColor System.String = false
- equalAverage System.Boolean = null
BelowAverage(System.Boolean equalAverage, System.Nullable{System.UInt32} standardDeviation) #Applies a below-average rule.
Parameters
- equalAverage System.Boolean
- standardDeviation System.Nullable{System.UInt32}
Between 2 overloads
public ExcelRange Between(String formula1, String formula2) #Returns:
ExcelRangeApplies a between cell-value rule.
Parameters
- formula1 System.String
- formula2 System.String
public ExcelRange Between(String formula1, String formula2, String fillColor) #Returns:
ExcelRangeApplies a between cell-value rule.
Parameters
- formula1 System.String
- formula2 System.String
- fillColor System.String
Bottom 2 overloads
public ExcelRange Bottom(UInt32 rank, Boolean percent = false) #Returns:
ExcelRangeApplies a bottom-values rule.
Parameters
- rank System.UInt32
- percent System.Boolean = false
public ExcelRange Bottom(UInt32 rank, String fillColor, Boolean percent = false) #Returns:
ExcelRangeApplies a bottom-values rule with an optional solid fill.
Parameters
- rank System.UInt32
- fillColor System.String
- percent System.Boolean = false
CellIs 3 overloads
public ExcelRange CellIs(ConditionalFormattingOperatorValues operator, String formula1) #Returns:
ExcelRangeApplies a cell-value comparison rule.
Parameters
- operator DocumentFormat.OpenXml.Spreadsheet.ConditionalFormattingOperatorValues
- formula1 System.String
public ExcelRange CellIs(ConditionalFormattingOperatorValues operator, String formula1, String formula2) #Returns:
ExcelRangeApplies a cell-value comparison rule.
Parameters
- operator DocumentFormat.OpenXml.Spreadsheet.ConditionalFormattingOperatorValues
- formula1 System.String
- formula2 System.String
public ExcelRange CellIs(ConditionalFormattingOperatorValues operator, String formula1, String formula2 = null, String fillColor = null) #Returns:
ExcelRangeApplies a cell-value comparison rule.
Parameters
- operator DocumentFormat.OpenXml.Spreadsheet.ConditionalFormattingOperatorValues
- formula1 System.String
- formula2 System.String = null
- fillColor System.String = null
public ExcelRange Clear() #Returns:
ExcelRangeRemoves conditional formatting rules that overlap the range.
ColorScale 2 overloads
public ExcelRange ColorScale(OfficeColor startColor, OfficeColor endColor) #Returns:
ExcelRangeApplies a two-color scale.
Parameters
- arg1 OfficeIMO.Drawing.OfficeColor
- arg2 OfficeIMO.Drawing.OfficeColor
public ExcelRange ColorScale(String startColor, String endColor) #Returns:
ExcelRangeApplies a two-color scale using hex colors.
Parameters
- startColor System.String
- endColor System.String
ContainsText 2 overloads
public ExcelRange ContainsText(String text) #Returns:
ExcelRangeApplies a contains-text rule.
Parameters
- text System.String
public ExcelRange ContainsText(String text, String fillColor) #Returns:
ExcelRangeApplies a contains-text rule with an optional solid fill.
Parameters
- text System.String
- fillColor System.String
DataBar 2 overloads
DuplicateValues 2 overloads
public ExcelRange EndsWith(String text) #Returns:
ExcelRangeApplies an ends-with text rule.
Parameters
- text System.String
EndsWithText 2 overloads
public ExcelRange EndsWithText(String text) #Returns:
ExcelRangeApplies an ends-with-text rule.
Parameters
- text System.String
public ExcelRange EndsWithText(String text, String fillColor) #Returns:
ExcelRangeApplies an ends-with-text rule with an optional solid fill.
Parameters
- text System.String
- fillColor System.String
Formula 3 overloads
public ExcelRange Formula(String formula) #Returns:
ExcelRangeApplies a formula-based rule.
Parameters
- formula System.String
public ExcelRange Formula(String formula, Boolean stopIfTrue) #Returns:
ExcelRangeApplies a formula-based rule.
Parameters
- formula System.String
- stopIfTrue System.Boolean
public ExcelRange Formula(String formula, Boolean stopIfTrue = false, String fillColor = null) #Returns:
ExcelRangeApplies a formula-based rule.
Parameters
- formula System.String
- stopIfTrue System.Boolean = false
- fillColor System.String = null
GreaterThan 2 overloads
public ExcelRange GreaterThan(String formula) #Returns:
ExcelRangeApplies a greater-than cell-value rule.
Parameters
- formula System.String
public ExcelRange GreaterThan(String formula, String fillColor) #Returns:
ExcelRangeApplies a greater-than cell-value rule.
Parameters
- formula System.String
- fillColor System.String
IconSet 2 overloads
public ExcelRange IconSet(IconSetValues iconSet, Boolean showValue = true, Boolean reverseIconOrder = false, Double[] percentThresholds = null, Double[] numberThresholds = null) #Returns:
ExcelRangeApplies an icon set.
Parameters
- iconSet DocumentFormat.OpenXml.Spreadsheet.IconSetValues
- showValue System.Boolean = true
- reverseIconOrder System.Boolean = false
- percentThresholds System.Double[] = null
- numberThresholds System.Double[] = null
LessThan 2 overloads
public ExcelRange LessThan(String formula) #Returns:
ExcelRangeApplies a less-than cell-value rule.
Parameters
- formula System.String
public ExcelRange LessThan(String formula, String fillColor) #Returns:
ExcelRangeApplies a less-than cell-value rule.
Parameters
- formula System.String
- fillColor System.String
NotContainsText 2 overloads
public ExcelRange NotContainsText(String text) #Returns:
ExcelRangeApplies a not-contains-text rule.
Parameters
- text System.String
public ExcelRange NotContainsText(String text, String fillColor) #Returns:
ExcelRangeApplies a not-contains-text rule with an optional solid fill.
Parameters
- text System.String
- fillColor System.String
TimePeriod 2 overloads
public ExcelRange TimePeriod(TimePeriodValues timePeriod) #Returns:
ExcelRangeApplies a time-period rule.
Parameters
- timePeriod DocumentFormat.OpenXml.Spreadsheet.TimePeriodValues
public ExcelRange TimePeriod(TimePeriodValues timePeriod, String fillColor) #Returns:
ExcelRangeApplies a time-period rule with a differential fill color.
Parameters
- timePeriod DocumentFormat.OpenXml.Spreadsheet.TimePeriodValues
- fillColor System.String
Top 2 overloads
public ExcelRange Top(UInt32 rank, Boolean percent = false) #Returns:
ExcelRangeApplies a top-values rule.
Parameters
- rank System.UInt32
- percent System.Boolean = false
public ExcelRange Top(UInt32 rank, String fillColor, Boolean percent = false) #Returns:
ExcelRangeApplies a top-values rule with an optional solid fill.
Parameters
- rank System.UInt32
- fillColor System.String
- percent System.Boolean = false
Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object