Class ExcelConditionalFormattingCollection

Collection of all ConditionalFormattings in the workbook

Inheritance
System.Object
ExcelConditionalFormattingCollection
Implements
System.Collections.Generic.IEnumerable<IExcelConditionalFormattingRule>
System.Collections.IEnumerable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.ConditionalFormatting
Assembly: EPPlus.dll
Syntax
public class ExcelConditionalFormattingCollection : IEnumerable<IExcelConditionalFormattingRule>, IEnumerable

Properties

Count

Number of validations

Declaration
public int Count { get; }
Property Value
Type Description
System.Int32

Item[Int32]

Index operator, returns by 0-based index

Declaration
public ExcelConditionalFormattingRule this[int index] { get; set; }
Parameters
Type Name Description
System.Int32 index
Property Value
Type Description
ExcelConditionalFormattingRule

Methods

AddAboveAverage(ExcelAddress)

Add AboveAverage Rule

Declaration
public IExcelConditionalFormattingAverageGroup AddAboveAverage(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingAverageGroup

AddAboveAverage(String)

Add AboveAverage Rule

Declaration
public IExcelConditionalFormattingAverageGroup AddAboveAverage(string address)
Parameters
Type Name Description
System.String address

String must be a valid excelAddress
Returns
Type Description
IExcelConditionalFormattingAverageGroup

AddAboveOrEqualAverage(ExcelAddress)

Add AboveOrEqualAverage Rule

Declaration
public IExcelConditionalFormattingAverageGroup AddAboveOrEqualAverage(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingAverageGroup

AddAboveOrEqualAverage(String)

Add AboveOrEqualAverage Rule

Declaration
public IExcelConditionalFormattingAverageGroup AddAboveOrEqualAverage(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingAverageGroup

AddAboveStdDev(ExcelAddress)

Add AboveStdDev Rule

Declaration
public IExcelConditionalFormattingStdDevGroup AddAboveStdDev(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingStdDevGroup

AddAboveStdDev(String)

Add AboveStdDev Rule

Declaration
public IExcelConditionalFormattingStdDevGroup AddAboveStdDev(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingStdDevGroup

AddBeginsWith(ExcelAddress)

Add BeginsWith Rule

Declaration
public IExcelConditionalFormattingBeginsWith AddBeginsWith(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingBeginsWith

AddBeginsWith(String)

Add BeginsWith Rule

Declaration
public IExcelConditionalFormattingBeginsWith AddBeginsWith(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingBeginsWith

AddBelowAverage(ExcelAddress)

Add BelowAverage Rule

Declaration
public IExcelConditionalFormattingAverageGroup AddBelowAverage(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingAverageGroup

AddBelowAverage(String)

Add BelowAverage Rule

Declaration
public IExcelConditionalFormattingAverageGroup AddBelowAverage(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingAverageGroup

AddBelowOrEqualAverage(ExcelAddress)

Add BelowOrEqualAverage Rule

Declaration
public IExcelConditionalFormattingAverageGroup AddBelowOrEqualAverage(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingAverageGroup

AddBelowOrEqualAverage(String)

Add BelowOrEqualAverage Rule

Declaration
public IExcelConditionalFormattingAverageGroup AddBelowOrEqualAverage(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingAverageGroup

AddBelowStdDev(ExcelAddress)

Add BelowStdDev Rule

Declaration
public IExcelConditionalFormattingStdDevGroup AddBelowStdDev(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingStdDevGroup

AddBelowStdDev(String)

Add BelowStdDev Rule

Declaration
public IExcelConditionalFormattingStdDevGroup AddBelowStdDev(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingStdDevGroup

AddBetween(ExcelAddress)

Add between rule

Declaration
public IExcelConditionalFormattingBetween AddBetween(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingBetween

AddBetween(String)

Add between rule

Declaration
public IExcelConditionalFormattingBetween AddBetween(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingBetween

AddBottom(ExcelAddress)

Add Bottom Rule

Declaration
public IExcelConditionalFormattingTopBottomGroup AddBottom(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTopBottomGroup

AddBottom(String)

Add Bottom Rule

Declaration
public IExcelConditionalFormattingTopBottomGroup AddBottom(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTopBottomGroup

AddBottomPercent(ExcelAddress)

Add BottomPercent Rule

Declaration
public IExcelConditionalFormattingTopBottomGroup AddBottomPercent(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTopBottomGroup

AddBottomPercent(String)

Add BottomPercent Rule

Declaration
public IExcelConditionalFormattingTopBottomGroup AddBottomPercent(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTopBottomGroup

AddContainsBlanks(ExcelAddress)

Add ContainsBlanks Rule

Declaration
public IExcelConditionalFormattingContainsBlanks AddContainsBlanks(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingContainsBlanks

AddContainsBlanks(String)

Add ContainsBlanks Rule

Declaration
public IExcelConditionalFormattingContainsBlanks AddContainsBlanks(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingContainsBlanks

AddContainsErrors(ExcelAddress)

Add ContainsErrors Rule

Declaration
public IExcelConditionalFormattingContainsErrors AddContainsErrors(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingContainsErrors

AddContainsErrors(String)

Add ContainsErrors Rule

Declaration
public IExcelConditionalFormattingContainsErrors AddContainsErrors(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingContainsErrors

AddContainsText(ExcelAddress)

Add ContainsText Rule

Declaration
public IExcelConditionalFormattingContainsText AddContainsText(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingContainsText

AddContainsText(String)

Add ContainsText Rule

Declaration
public IExcelConditionalFormattingContainsText AddContainsText(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingContainsText

AddDatabar(ExcelAddress, Color)

Adds a databar rule

Declaration
public IExcelConditionalFormattingDataBarGroup AddDatabar(ExcelAddress Address, Color color)
Parameters
Type Name Description
ExcelAddress Address
System.Drawing.Color color
Returns
Type Description
IExcelConditionalFormattingDataBarGroup

AddDatabar(String, Color)

Adds a databar rule

Declaration
public IExcelConditionalFormattingDataBarGroup AddDatabar(string Address, Color color)
Parameters
Type Name Description
System.String Address
System.Drawing.Color color
Returns
Type Description
IExcelConditionalFormattingDataBarGroup

AddDuplicateValues(ExcelAddress)

Add DuplicateValues Rule

Declaration
public IExcelConditionalFormattingDuplicateValues AddDuplicateValues(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingDuplicateValues

AddDuplicateValues(String)

Add DuplicateValues Rule

Declaration
public IExcelConditionalFormattingDuplicateValues AddDuplicateValues(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingDuplicateValues

AddEndsWith(ExcelAddress)

Add EndsWith Rule

Declaration
public IExcelConditionalFormattingEndsWith AddEndsWith(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingEndsWith

AddEndsWith(String)

Add EndsWith Rule

Declaration
public IExcelConditionalFormattingEndsWith AddEndsWith(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingEndsWith

AddEqual(ExcelAddress)

Add Equal rule

Declaration
public IExcelConditionalFormattingEqual AddEqual(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingEqual

AddEqual(String)

Add Equal rule

Declaration
public IExcelConditionalFormattingEqual AddEqual(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingEqual

AddExpression(ExcelAddress)

Add Expression Rule

Declaration
public IExcelConditionalFormattingExpression AddExpression(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingExpression

AddExpression(String)

Add Expression Rule

Declaration
public IExcelConditionalFormattingExpression AddExpression(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingExpression

AddFiveIconSet(ExcelAddress, eExcelconditionalFormatting5IconsSetType)

Adds a FiveIconSet rule

Declaration
public IExcelConditionalFormattingFiveIconSet AddFiveIconSet(ExcelAddress Address, eExcelconditionalFormatting5IconsSetType IconSet)
Parameters
Type Name Description
ExcelAddress Address
eExcelconditionalFormatting5IconsSetType IconSet
Returns
Type Description
IExcelConditionalFormattingFiveIconSet

AddFiveIconSet(String, eExcelconditionalFormatting5IconsSetType)

Adds a FiveIconSet rule

Declaration
public IExcelConditionalFormattingFiveIconSet AddFiveIconSet(string Address, eExcelconditionalFormatting5IconsSetType IconSet)
Parameters
Type Name Description
System.String Address
eExcelconditionalFormatting5IconsSetType IconSet
Returns
Type Description
IExcelConditionalFormattingFiveIconSet

AddFourIconSet(ExcelAddress, eExcelconditionalFormatting4IconsSetType)

Adds a FourIconSet rule

Declaration
public IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType> AddFourIconSet(ExcelAddress Address, eExcelconditionalFormatting4IconsSetType IconSet)
Parameters
Type Name Description
ExcelAddress Address
eExcelconditionalFormatting4IconsSetType IconSet
Returns
Type Description
IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType>

AddFourIconSet(String, eExcelconditionalFormatting4IconsSetType)

Adds a FourIconSet rule

Declaration
public IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType> AddFourIconSet(string Address, eExcelconditionalFormatting4IconsSetType IconSet)
Parameters
Type Name Description
System.String Address
eExcelconditionalFormatting4IconsSetType IconSet
Returns
Type Description
IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType>

AddGreaterThan(ExcelAddress)

Add GreaterThan Rule

Declaration
public IExcelConditionalFormattingGreaterThan AddGreaterThan(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingGreaterThan

AddGreaterThan(String)

Add GreaterThan Rule

Declaration
public IExcelConditionalFormattingGreaterThan AddGreaterThan(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingGreaterThan

AddGreaterThanOrEqual(ExcelAddress)

Add GreaterThanOrEqual Rule

Declaration
public IExcelConditionalFormattingGreaterThanOrEqual AddGreaterThanOrEqual(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingGreaterThanOrEqual

AddGreaterThanOrEqual(String)

Add GreaterThanOrEqual Rule

Declaration
public IExcelConditionalFormattingGreaterThanOrEqual AddGreaterThanOrEqual(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingGreaterThanOrEqual

AddLast7Days(ExcelAddress)

Add Last7Days rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddLast7Days(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddLast7Days(String)

Add Last7Days rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddLast7Days(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddLastMonth(ExcelAddress)

Add last month rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddLastMonth(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddLastMonth(String)

Add last month rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddLastMonth(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddLastWeek(ExcelAddress)

Add lastWeek rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddLastWeek(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddLastWeek(String)

Add lastWeek rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddLastWeek(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddLessThan(ExcelAddress)

Add LessThan Rule

Declaration
public IExcelConditionalFormattingLessThan AddLessThan(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingLessThan

AddLessThan(String)

Add LessThan Rule

Declaration
public IExcelConditionalFormattingLessThan AddLessThan(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingLessThan

AddLessThanOrEqual(ExcelAddress)

Add LessThanOrEqual Rule

Declaration
public IExcelConditionalFormattingLessThanOrEqual AddLessThanOrEqual(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingLessThanOrEqual

AddLessThanOrEqual(String)

Add LessThanOrEqual Rule

Declaration
public IExcelConditionalFormattingLessThanOrEqual AddLessThanOrEqual(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingLessThanOrEqual

AddNextMonth(ExcelAddress)

Add NextMonth rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddNextMonth(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddNextMonth(String)

Add NextMonth rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddNextMonth(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddNextWeek(ExcelAddress)

Add next week rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddNextWeek(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddNextWeek(String)

Add next week rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddNextWeek(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddNotBetween(ExcelAddress)

Add NotBetween Rule

Declaration
public IExcelConditionalFormattingNotBetween AddNotBetween(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingNotBetween

AddNotBetween(String)

Add NotBetween Rule

Declaration
public IExcelConditionalFormattingNotBetween AddNotBetween(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingNotBetween

AddNotContainsBlanks(ExcelAddress)

Add NotContainsBlanks Rule

Declaration
public IExcelConditionalFormattingNotContainsBlanks AddNotContainsBlanks(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingNotContainsBlanks

AddNotContainsBlanks(String)

Add NotContainsBlanks Rule

Declaration
public IExcelConditionalFormattingNotContainsBlanks AddNotContainsBlanks(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingNotContainsBlanks

AddNotContainsErrors(ExcelAddress)

Add NotContainsErrors Rule

Declaration
public IExcelConditionalFormattingNotContainsErrors AddNotContainsErrors(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingNotContainsErrors

AddNotContainsErrors(String)

Add NotContainsErrors Rule

Declaration
public IExcelConditionalFormattingNotContainsErrors AddNotContainsErrors(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingNotContainsErrors

AddNotContainsText(ExcelAddress)

Add NotContainsText Rule

Declaration
public IExcelConditionalFormattingNotContainsText AddNotContainsText(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingNotContainsText

AddNotContainsText(String)

Add NotContainsText Rule

Declaration
public IExcelConditionalFormattingNotContainsText AddNotContainsText(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingNotContainsText

AddNotEqual(ExcelAddress)

Add NotEqual Rule

Declaration
public IExcelConditionalFormattingNotEqual AddNotEqual(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingNotEqual

AddNotEqual(String)

Add NotEqual Rule

Declaration
public IExcelConditionalFormattingNotEqual AddNotEqual(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingNotEqual

AddTextContains(ExcelAddress)

Add TextContains rule

Declaration
public IExcelConditionalFormattingContainsText AddTextContains(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingContainsText

AddTextContains(String)

Add TextContains rule

Declaration
public IExcelConditionalFormattingContainsText AddTextContains(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingContainsText

AddThisMonth(ExcelAddress)

Add ThisMonth rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddThisMonth(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddThisMonth(String)

Add ThisMonth rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddThisMonth(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddThisWeek(ExcelAddress)

Add this week rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddThisWeek(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddThisWeek(String)

Add this week rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddThisWeek(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddThreeColorScale(ExcelAddress)

Add ThreeColorScale Rule

Declaration
public IExcelConditionalFormattingThreeColorScale AddThreeColorScale(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingThreeColorScale

AddThreeColorScale(String)

Add ThreeColorScale Rule

Declaration
public IExcelConditionalFormattingThreeColorScale AddThreeColorScale(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingThreeColorScale

AddThreeIconSet(ExcelAddress, eExcelconditionalFormatting3IconsSetType)

Add ThreeIconSet Rule

Declaration
public IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType> AddThreeIconSet(ExcelAddress Address, eExcelconditionalFormatting3IconsSetType IconSet)
Parameters
Type Name Description
ExcelAddress Address

The address
eExcelconditionalFormatting3IconsSetType IconSet

Type of iconset
Returns
Type Description
IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType>

AddThreeIconSet(String, eExcelconditionalFormatting3IconsSetType)

Add ThreeIconSet Rule

Declaration
public IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType> AddThreeIconSet(string Address, eExcelconditionalFormatting3IconsSetType IconSet)
Parameters
Type Name Description
System.String Address

The address
eExcelconditionalFormatting3IconsSetType IconSet

Type of iconset
Returns
Type Description
IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType>

AddToday(ExcelAddress)

Add Today rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddToday(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddToday(String)

Add Today rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddToday(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddTomorrow(ExcelAddress)

Add Tomorrow rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddTomorrow(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddTomorrow(String)

Add Tomorrow rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddTomorrow(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddTop(ExcelAddress)

Add Top Rule

Declaration
public IExcelConditionalFormattingTopBottomGroup AddTop(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTopBottomGroup

AddTop(String)

Add Top Rule

Declaration
public IExcelConditionalFormattingTopBottomGroup AddTop(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTopBottomGroup

AddTopPercent(ExcelAddress)

Add TopPercent Rule

Declaration
public IExcelConditionalFormattingTopBottomGroup AddTopPercent(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTopBottomGroup

AddTopPercent(String)

Add TopPercent Rule

Declaration
public IExcelConditionalFormattingTopBottomGroup AddTopPercent(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTopBottomGroup

AddTwoColorScale(ExcelAddress)

Add TwoColorScale Rule

Declaration
public IExcelConditionalFormattingTwoColorScale AddTwoColorScale(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTwoColorScale

AddTwoColorScale(String)

Add TwoColorScale Rule

Declaration
public IExcelConditionalFormattingTwoColorScale AddTwoColorScale(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTwoColorScale

AddUniqueValues(ExcelAddress)

Add Unique Rule

Declaration
public IExcelConditionalFormattingUniqueValues AddUniqueValues(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingUniqueValues

AddUniqueValues(String)

Add Unique Rule

Declaration
public IExcelConditionalFormattingUniqueValues AddUniqueValues(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingUniqueValues

AddYesterday(ExcelAddress)

Add Yesterday rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddYesterday(ExcelAddress address)
Parameters
Type Name Description
ExcelAddress address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

AddYesterday(String)

Add Yesterday rule

Declaration
public IExcelConditionalFormattingTimePeriodGroup AddYesterday(string address)
Parameters
Type Name Description
System.String address
Returns
Type Description
IExcelConditionalFormattingTimePeriodGroup

Remove(IExcelConditionalFormattingRule)

Remove a Conditional Formatting Rule by its object

Declaration
public void Remove(IExcelConditionalFormattingRule item)
Parameters
Type Name Description
IExcelConditionalFormattingRule item

RemoveAll()

Removes all 'cfRule' from the collection and from the XML. This is the same as removing all the 'conditionalFormatting' nodes.

Declaration
public void RemoveAll()

RemoveAt(Int32)

Remove a Conditional Formatting Rule by its 0-based index

Declaration
public void RemoveAt(int index)
Parameters
Type Name Description
System.Int32 index

RemoveByPriority(Int32)

Remove a Conditional Formatting Rule by its priority

Declaration
public void RemoveByPriority(int priority)
Parameters
Type Name Description
System.Int32 priority

RulesByPriority(Int32)

Get a rule by its priority

Declaration
public IExcelConditionalFormattingRule RulesByPriority(int priority)
Parameters
Type Name Description
System.Int32 priority
Returns
Type Description
IExcelConditionalFormattingRule

Explicit Interface Implementations

IEnumerable<IExcelConditionalFormattingRule>.GetEnumerator()

Declaration
IEnumerator<IExcelConditionalFormattingRule> IEnumerable<IExcelConditionalFormattingRule>.GetEnumerator()
Returns
Type Description
System.Collections.Generic.IEnumerator<IExcelConditionalFormattingRule>

IEnumerable.GetEnumerator()

Declaration
IEnumerator IEnumerable.GetEnumerator()
Returns
Type Description
System.Collections.IEnumerator

Implements

System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable