Interface IRangeConditionalFormatting¶

Namespace: OfficeOpenXml.ConditionalFormatting
Assembly: EPPlus.dll

Provides functionality for adding Conditional Formatting to a range (ExcelRangeBase). Each method will return a configurable condtional formatting type.

public interface IRangeConditionalFormatting

Methods¶

AddAboveAverage()¶

Adds an Above Average rule to the range

IExcelConditionalFormattingAverageGroup AddAboveAverage()

Returns¶

IExcelConditionalFormattingAverageGroup

AddAboveOrEqualAverage()¶

Adds an Above Or Equal Average rule to the range

IExcelConditionalFormattingAverageGroup AddAboveOrEqualAverage()

Returns¶

IExcelConditionalFormattingAverageGroup

AddAboveStdDev()¶

Adds an Above StdDev rule to the range

IExcelConditionalFormattingStdDevGroup AddAboveStdDev()

Returns¶

IExcelConditionalFormattingStdDevGroup

AddBeginsWith()¶

Adds a Begins With rule to the range

IExcelConditionalFormattingBeginsWith AddBeginsWith()

Returns¶

IExcelConditionalFormattingBeginsWith

AddBelowAverage()¶

Adds a Below Average rule to the range

IExcelConditionalFormattingAverageGroup AddBelowAverage()

Returns¶

IExcelConditionalFormattingAverageGroup

AddBelowOrEqualAverage()¶

Adds a Below Or Equal Average rule to the range

IExcelConditionalFormattingAverageGroup AddBelowOrEqualAverage()

Returns¶

IExcelConditionalFormattingAverageGroup

AddBelowStdDev()¶

Adds an Below StdDev rule to the range

IExcelConditionalFormattingStdDevGroup AddBelowStdDev()

Returns¶

IExcelConditionalFormattingStdDevGroup

AddBetween()¶

Adds a Between rule to the range

IExcelConditionalFormattingBetween AddBetween()

Returns¶

IExcelConditionalFormattingBetween

AddBottom()¶

Adds a Bottom rule to the range

IExcelConditionalFormattingTopBottomGroup AddBottom()

Returns¶

IExcelConditionalFormattingTopBottomGroup

AddBottomPercent()¶

Adds a Bottom Percent rule to the range

IExcelConditionalFormattingTopBottomGroup AddBottomPercent()

Returns¶

IExcelConditionalFormattingTopBottomGroup

AddContainsBlanks()¶

Adds a ContainsBlanks rule to the range

IExcelConditionalFormattingContainsBlanks AddContainsBlanks()

Returns¶

IExcelConditionalFormattingContainsBlanks

AddContainsErrors()¶

Adds a ContainsErrors rule to the range

IExcelConditionalFormattingContainsErrors AddContainsErrors()

Returns¶

IExcelConditionalFormattingContainsErrors

AddContainsText()¶

Adds a ContainsText rule to the range

IExcelConditionalFormattingContainsText AddContainsText()

Returns¶

IExcelConditionalFormattingContainsText

AddDatabar(Color)¶

Adds a IExcelConditionalFormattingDataBarGroup to the range

IExcelConditionalFormattingDataBarGroup AddDatabar(Color color)

Parameters¶

color Color

Returns¶

IExcelConditionalFormattingDataBarGroup

AddDuplicateValues()¶

Adds a DuplicateValues rule to the range

IExcelConditionalFormattingDuplicateValues AddDuplicateValues()

Returns¶

IExcelConditionalFormattingDuplicateValues

AddEndsWith()¶

Adds an EndsWith rule to the range

IExcelConditionalFormattingEndsWith AddEndsWith()

Returns¶

IExcelConditionalFormattingEndsWith

AddEqual()¶

Adds an Equal rule to the range

IExcelConditionalFormattingEqual AddEqual()

Returns¶

IExcelConditionalFormattingEqual

AddExpression()¶

Adds an Expression rule to the range

IExcelConditionalFormattingExpression AddExpression()

Returns¶

IExcelConditionalFormattingExpression

AddFiveIconSet(eExcelconditionalFormatting5IconsSetType)¶

Adds a IExcelConditionalFormattingFiveIconSet to the range

IExcelConditionalFormattingFiveIconSet AddFiveIconSet(eExcelconditionalFormatting5IconsSetType IconSet)

Parameters¶

IconSet eExcelconditionalFormatting5IconsSetType

Returns¶

IExcelConditionalFormattingFiveIconSet

AddFourIconSet(eExcelconditionalFormatting4IconsSetType)¶

Adds a IExcelConditionalFormattingFourIconSet`1 to the range

IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType> AddFourIconSet(eExcelconditionalFormatting4IconsSetType IconSet)

Parameters¶

IconSet eExcelconditionalFormatting4IconsSetType

Returns¶

IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType>

AddGreaterThan()¶

Adds a GreaterThan rule to the range

IExcelConditionalFormattingGreaterThan AddGreaterThan()

Returns¶

IExcelConditionalFormattingGreaterThan

AddGreaterThanOrEqual()¶

Adds a GreaterThanOrEqual rule to the range

IExcelConditionalFormattingGreaterThanOrEqual AddGreaterThanOrEqual()

Returns¶

IExcelConditionalFormattingGreaterThanOrEqual

AddLast7Days()¶

Adds a Last 7 Days rule to the range

IExcelConditionalFormattingTimePeriodGroup AddLast7Days()

Returns¶

IExcelConditionalFormattingTimePeriodGroup

AddLastMonth()¶

Adds a Last Month rule to the range

IExcelConditionalFormattingTimePeriodGroup AddLastMonth()

Returns¶

IExcelConditionalFormattingTimePeriodGroup

AddLastWeek()¶

Adds a Last Week rule to the range

IExcelConditionalFormattingTimePeriodGroup AddLastWeek()

Returns¶

IExcelConditionalFormattingTimePeriodGroup

AddLessThan()¶

Adds a LessThan rule to the range

IExcelConditionalFormattingLessThan AddLessThan()

Returns¶

IExcelConditionalFormattingLessThan

AddLessThanOrEqual()¶

Adds a LessThanOrEqual rule to the range

IExcelConditionalFormattingLessThanOrEqual AddLessThanOrEqual()

Returns¶

IExcelConditionalFormattingLessThanOrEqual

AddNextMonth()¶

Adds a Next Month rule to the range

IExcelConditionalFormattingTimePeriodGroup AddNextMonth()

Returns¶

IExcelConditionalFormattingTimePeriodGroup

AddNextWeek()¶

Adds a Next Week rule to the range

IExcelConditionalFormattingTimePeriodGroup AddNextWeek()

Returns¶

IExcelConditionalFormattingTimePeriodGroup

AddNotBetween()¶

Adds a NotBetween rule to the range

IExcelConditionalFormattingNotBetween AddNotBetween()

Returns¶

IExcelConditionalFormattingNotBetween

AddNotContainsBlanks()¶

Adds a NotContainsBlanks rule to the range

IExcelConditionalFormattingNotContainsBlanks AddNotContainsBlanks()

Returns¶

IExcelConditionalFormattingNotContainsBlanks

AddNotContainsErrors()¶

Adds a NotContainsErrors rule to the range

IExcelConditionalFormattingNotContainsErrors AddNotContainsErrors()

Returns¶

IExcelConditionalFormattingNotContainsErrors

AddNotContainsText()¶

Adds a NotContainsText rule to the range

IExcelConditionalFormattingNotContainsText AddNotContainsText()

Returns¶

IExcelConditionalFormattingNotContainsText

AddNotEqual()¶

Adds a NotEqual rule to the range

IExcelConditionalFormattingNotEqual AddNotEqual()

Returns¶

IExcelConditionalFormattingNotEqual

AddThisMonth()¶

Adds a This Month rule to the range

IExcelConditionalFormattingTimePeriodGroup AddThisMonth()

Returns¶

IExcelConditionalFormattingTimePeriodGroup

AddThisWeek()¶

Adds a This Week rule to the range

IExcelConditionalFormattingTimePeriodGroup AddThisWeek()

Returns¶

IExcelConditionalFormattingTimePeriodGroup

AddThreeColorScale()¶

Adds a ExcelConditionalFormattingThreeColorScale to the range

IExcelConditionalFormattingThreeColorScale AddThreeColorScale()

Returns¶

IExcelConditionalFormattingThreeColorScale

AddThreeIconSet(eExcelconditionalFormatting3IconsSetType)¶

Adds a IExcelConditionalFormattingThreeIconSet`1 to the range

IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType> AddThreeIconSet(eExcelconditionalFormatting3IconsSetType IconSet)

Parameters¶

IconSet eExcelconditionalFormatting3IconsSetType

Returns¶

IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType>

AddToday()¶

Adds a Today rule to the range

IExcelConditionalFormattingTimePeriodGroup AddToday()

Returns¶

IExcelConditionalFormattingTimePeriodGroup

AddTomorrow()¶

Adds a Tomorrow rule to the range

IExcelConditionalFormattingTimePeriodGroup AddTomorrow()

Returns¶

IExcelConditionalFormattingTimePeriodGroup

AddTop()¶

Adds a Top rule to the range

IExcelConditionalFormattingTopBottomGroup AddTop()

Returns¶

IExcelConditionalFormattingTopBottomGroup

AddTopPercent()¶

Adds a Top Percent rule to the range

IExcelConditionalFormattingTopBottomGroup AddTopPercent()

Returns¶

IExcelConditionalFormattingTopBottomGroup

AddTwoColorScale()¶

Adds a ExcelConditionalFormattingTwoColorScale to the range

IExcelConditionalFormattingTwoColorScale AddTwoColorScale()

Returns¶

IExcelConditionalFormattingTwoColorScale

AddUniqueValues()¶

Adds an UniqueValues rule to the range

IExcelConditionalFormattingUniqueValues AddUniqueValues()

Returns¶

IExcelConditionalFormattingUniqueValues

AddYesterday()¶

Adds an Yesterday rule to the range

IExcelConditionalFormattingTimePeriodGroup AddYesterday()

Returns¶

IExcelConditionalFormattingTimePeriodGroup

GetConditionalFormattings()¶

Get dict of all CFs and their addresses in range

List<ExcelConditionalFormattingRule> GetConditionalFormattings()

Returns¶

List<ExcelConditionalFormattingRule>