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 IRangeConditionalFormattingMethods
AddAboveAverage()
Adds an Above Average rule to the range
IExcelConditionalFormattingAverageGroup AddAboveAverage()Returns
AddAboveOrEqualAverage()
Adds an Above Or Equal Average rule to the range
IExcelConditionalFormattingAverageGroup AddAboveOrEqualAverage()Returns
AddAboveStdDev()
Adds an Above StdDev rule to the range
IExcelConditionalFormattingStdDevGroup AddAboveStdDev()Returns
AddBeginsWith()
Adds a Begins With rule to the range
IExcelConditionalFormattingBeginsWith AddBeginsWith()Returns
AddBelowAverage()
Adds a Below Average rule to the range
IExcelConditionalFormattingAverageGroup AddBelowAverage()Returns
AddBelowOrEqualAverage()
Adds a Below Or Equal Average rule to the range
IExcelConditionalFormattingAverageGroup AddBelowOrEqualAverage()Returns
AddBelowStdDev()
Adds an Below StdDev rule to the range
IExcelConditionalFormattingStdDevGroup AddBelowStdDev()Returns
AddBetween()
Adds a Between rule to the range
IExcelConditionalFormattingBetween AddBetween()Returns
AddBottom()
Adds a Bottom rule to the range
IExcelConditionalFormattingTopBottomGroup AddBottom()Returns
AddBottomPercent()
Adds a Bottom Percent rule to the range
IExcelConditionalFormattingTopBottomGroup AddBottomPercent()Returns
AddContainsBlanks()
Adds a ContainsBlanks rule to the range
IExcelConditionalFormattingContainsBlanks AddContainsBlanks()Returns
AddContainsErrors()
Adds a ContainsErrors rule to the range
IExcelConditionalFormattingContainsErrors AddContainsErrors()Returns
AddContainsText()
Adds a ContainsText rule to the range
IExcelConditionalFormattingContainsText AddContainsText()Returns
AddDatabar(Color)
Adds a IExcelConditionalFormattingDataBarGroup to the range
IExcelConditionalFormattingDataBarGroup AddDatabar(Color color)Parameters
colorColor
Returns
AddDuplicateValues()
Adds a DuplicateValues rule to the range
IExcelConditionalFormattingDuplicateValues AddDuplicateValues()Returns
AddEndsWith()
Adds an EndsWith rule to the range
IExcelConditionalFormattingEndsWith AddEndsWith()Returns
AddEqual()
Adds an Equal rule to the range
IExcelConditionalFormattingEqual AddEqual()Returns
AddExpression()
Adds an Expression rule to the range
IExcelConditionalFormattingExpression AddExpression()Returns
AddFiveIconSet(eExcelconditionalFormatting5IconsSetType)
Adds a IExcelConditionalFormattingFiveIconSet to the range
IExcelConditionalFormattingFiveIconSet AddFiveIconSet(eExcelconditionalFormatting5IconsSetType IconSet)Parameters
Returns
AddFourIconSet(eExcelconditionalFormatting4IconsSetType)
Adds a IExcelConditionalFormattingFourIconSet<T> to the range
IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType> AddFourIconSet(eExcelconditionalFormatting4IconsSetType IconSet)Parameters
Returns
AddGreaterThan()
Adds a GreaterThan rule to the range
IExcelConditionalFormattingGreaterThan AddGreaterThan()Returns
AddGreaterThanOrEqual()
Adds a GreaterThanOrEqual rule to the range
IExcelConditionalFormattingGreaterThanOrEqual AddGreaterThanOrEqual()Returns
AddLast7Days()
Adds a Last 7 Days rule to the range
IExcelConditionalFormattingTimePeriodGroup AddLast7Days()Returns
AddLastMonth()
Adds a Last Month rule to the range
IExcelConditionalFormattingTimePeriodGroup AddLastMonth()Returns
AddLastWeek()
Adds a Last Week rule to the range
IExcelConditionalFormattingTimePeriodGroup AddLastWeek()Returns
AddLessThan()
Adds a LessThan rule to the range
IExcelConditionalFormattingLessThan AddLessThan()Returns
AddLessThanOrEqual()
Adds a LessThanOrEqual rule to the range
IExcelConditionalFormattingLessThanOrEqual AddLessThanOrEqual()Returns
AddNextMonth()
Adds a Next Month rule to the range
IExcelConditionalFormattingTimePeriodGroup AddNextMonth()Returns
AddNextWeek()
Adds a Next Week rule to the range
IExcelConditionalFormattingTimePeriodGroup AddNextWeek()Returns
AddNotBetween()
Adds a NotBetween rule to the range
IExcelConditionalFormattingNotBetween AddNotBetween()Returns
AddNotContainsBlanks()
Adds a NotContainsBlanks rule to the range
IExcelConditionalFormattingNotContainsBlanks AddNotContainsBlanks()Returns
AddNotContainsErrors()
Adds a NotContainsErrors rule to the range
IExcelConditionalFormattingNotContainsErrors AddNotContainsErrors()Returns
AddNotContainsText()
Adds a NotContainsText rule to the range
IExcelConditionalFormattingNotContainsText AddNotContainsText()Returns
AddNotEqual()
Adds a NotEqual rule to the range
IExcelConditionalFormattingNotEqual AddNotEqual()Returns
AddThisMonth()
Adds a This Month rule to the range
IExcelConditionalFormattingTimePeriodGroup AddThisMonth()Returns
AddThisWeek()
Adds a This Week rule to the range
IExcelConditionalFormattingTimePeriodGroup AddThisWeek()Returns
AddThreeColorScale()
Adds a ExcelConditionalFormattingThreeColorScale to the range
IExcelConditionalFormattingThreeColorScale AddThreeColorScale()Returns
AddThreeIconSet(eExcelconditionalFormatting3IconsSetType)
Adds a IExcelConditionalFormattingThreeIconSet<T> to the range
IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType> AddThreeIconSet(eExcelconditionalFormatting3IconsSetType IconSet)Parameters
Returns
AddToday()
Adds a Today rule to the range
IExcelConditionalFormattingTimePeriodGroup AddToday()Returns
AddTomorrow()
Adds a Tomorrow rule to the range
IExcelConditionalFormattingTimePeriodGroup AddTomorrow()Returns
AddTop()
Adds a Top rule to the range
IExcelConditionalFormattingTopBottomGroup AddTop()Returns
AddTopPercent()
Adds a Top Percent rule to the range
IExcelConditionalFormattingTopBottomGroup AddTopPercent()Returns
AddTwoColorScale()
Adds a ExcelConditionalFormattingTwoColorScale to the range
IExcelConditionalFormattingTwoColorScale AddTwoColorScale()Returns
AddUniqueValues()
Adds an UniqueValues rule to the range
IExcelConditionalFormattingUniqueValues AddUniqueValues()Returns
AddYesterday()
Adds an Yesterday rule to the range
IExcelConditionalFormattingTimePeriodGroup AddYesterday()Returns
GetConditionalFormattings()
Get a list of all conditional formatting rules that exist on cells in the range
List<ExcelConditionalFormattingRule> GetConditionalFormattings()