Get Started

API Reference

Class

ExcelRangeConditionalFormattingBuilder

Edit on GitHub
Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Source OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:19
Modifiers sealed

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

Methods

public ExcelRange Between(String formula1, String formula2) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:41
Returns: ExcelRange

Applies a between cell-value rule.

Parameters

formula1 System.String requiredposition: 0
formula2 System.String requiredposition: 1
public ExcelRange Bottom(UInt32 rank, Boolean percent = false) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:72
Returns: ExcelRange

Applies a bottom-values rule.

Parameters

rank System.UInt32 requiredposition: 0
percent System.Boolean = false optionalposition: 1
public ExcelRange CellIs(ConditionalFormattingOperatorValues operator, String formula1, String formula2 = null) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:19
Returns: ExcelRange

Applies a cell-value comparison rule.

Parameters

operator DocumentFormat.OpenXml.Spreadsheet.ConditionalFormattingOperatorValues requiredposition: 0
formula1 System.String requiredposition: 1
formula2 System.String = null optionalposition: 2
public ExcelRange Clear() #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:127
Returns: ExcelRange

Removes conditional formatting rules that overlap the range.

ColorScale 2 overloads
public ExcelRange ColorScale(OfficeColor startColor, OfficeColor endColor) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:80
Returns: ExcelRange

Applies a two-color scale.

Parameters

arg1 OfficeIMO.Drawing.OfficeColor requiredposition: 0
arg2 OfficeIMO.Drawing.OfficeColor requiredposition: 1
public ExcelRange ColorScale(String startColor, String endColor) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:88
Returns: ExcelRange

Applies a two-color scale using hex colors.

Parameters

startColor System.String requiredposition: 0
endColor System.String requiredposition: 1
DataBar 2 overloads
public ExcelRange DataBar(OfficeColor color) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:96
Returns: ExcelRange

Applies a data bar.

Parameters

arg1 OfficeIMO.Drawing.OfficeColor requiredposition: 0
public ExcelRange DataBar(String color) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:104
Returns: ExcelRange

Applies a data bar using a hex color.

Parameters

color System.String requiredposition: 0
public ExcelRange DuplicateValues() #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:56
Returns: ExcelRange

Applies a duplicate-values rule.

public ExcelRange Formula(String formula, Boolean stopIfTrue = false) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:48
Returns: ExcelRange

Applies a formula-based rule.

Parameters

formula System.String requiredposition: 0
stopIfTrue System.Boolean = false optionalposition: 1
public ExcelRange GreaterThan(String formula) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:27
Returns: ExcelRange

Applies a greater-than cell-value rule.

Parameters

formula System.String requiredposition: 0
IconSet 2 overloads
public ExcelRange IconSet() #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:112
Returns: ExcelRange

Applies an icon set.

public ExcelRange IconSet(IconSetValues iconSet, Boolean showValue = true, Boolean reverseIconOrder = false, Double[] percentThresholds = null, Double[] numberThresholds = null) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:119
Returns: ExcelRange

Applies an icon set.

Parameters

iconSet DocumentFormat.OpenXml.Spreadsheet.IconSetValues requiredposition: 0
showValue System.Boolean = true optionalposition: 1
reverseIconOrder System.Boolean = false optionalposition: 2
percentThresholds System.Double[] = null optionalposition: 3
numberThresholds System.Double[] = null optionalposition: 4
public ExcelRange LessThan(String formula) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:34
Returns: ExcelRange

Applies a less-than cell-value rule.

Parameters

formula System.String requiredposition: 0
public ExcelRange Top(UInt32 rank, Boolean percent = false) #
OfficeIMO.Excel/ExcelRangeConditionalFormattingBuilder.cs:64
Returns: ExcelRange

Applies a top-values rule.

Parameters

rank System.UInt32 requiredposition: 0
percent System.Boolean = false optionalposition: 1