Interface IRangeConditionalFormatting
Provides functionality for adding Conditional Formatting to a range (ExcelRangeBase).
Each method will return a configurable condtional formatting type.
Assembly: EPPlus.dll
public interface IRangeConditionalFormatting
Methods
Adds an Above Average rule to the range
Declaration
IExcelConditionalFormattingAverageGroup AddAboveAverage()
Returns
Adds an Above Or Equal Average rule to the range
Declaration
IExcelConditionalFormattingAverageGroup AddAboveOrEqualAverage()
Returns
Adds an Above StdDev rule to the range
Declaration
IExcelConditionalFormattingStdDevGroup AddAboveStdDev()
Returns
Adds a Begins With rule to the range
Declaration
IExcelConditionalFormattingBeginsWith AddBeginsWith()
Returns
Adds a Below Average rule to the range
Declaration
IExcelConditionalFormattingAverageGroup AddBelowAverage()
Returns
Adds a Below Or Equal Average rule to the range
Declaration
IExcelConditionalFormattingAverageGroup AddBelowOrEqualAverage()
Returns
Adds an Below StdDev rule to the range
Declaration
IExcelConditionalFormattingStdDevGroup AddBelowStdDev()
Returns
Adds a Between rule to the range
Declaration
IExcelConditionalFormattingBetween AddBetween()
Returns
Adds a Bottom rule to the range
Declaration
IExcelConditionalFormattingTopBottomGroup AddBottom()
Returns
Adds a Bottom Percent rule to the range
Declaration
IExcelConditionalFormattingTopBottomGroup AddBottomPercent()
Returns
Adds a ContainsBlanks rule to the range
Declaration
IExcelConditionalFormattingContainsBlanks AddContainsBlanks()
Returns
Adds a ContainsErrors rule to the range
Declaration
IExcelConditionalFormattingContainsErrors AddContainsErrors()
Returns
AddContainsText()
Adds a ContainsText rule to the range
Declaration
IExcelConditionalFormattingContainsText AddContainsText()
Returns
Declaration
IExcelConditionalFormattingDataBarGroup AddDatabar(Color color)
Parameters
| Type |
Name |
Description |
| System.Drawing.Color |
color |
|
Returns
Adds a DuplicateValues rule to the range
Declaration
IExcelConditionalFormattingDuplicateValues AddDuplicateValues()
Returns
Adds an EndsWith rule to the range
Declaration
IExcelConditionalFormattingEndsWith AddEndsWith()
Returns
Adds an Equal rule to the range
Declaration
IExcelConditionalFormattingEqual AddEqual()
Returns
Adds an Expression rule to the range
Declaration
IExcelConditionalFormattingExpression AddExpression()
Returns
Declaration
IExcelConditionalFormattingFiveIconSet AddFiveIconSet(eExcelconditionalFormatting5IconsSetType IconSet)
Parameters
Returns
Declaration
IExcelConditionalFormattingFourIconSet<eExcelconditionalFormatting4IconsSetType> AddFourIconSet(eExcelconditionalFormatting4IconsSetType IconSet)
Parameters
Returns
Adds a GreaterThan rule to the range
Declaration
IExcelConditionalFormattingGreaterThan AddGreaterThan()
Returns
Adds a GreaterThanOrEqual rule to the range
Declaration
IExcelConditionalFormattingGreaterThanOrEqual AddGreaterThanOrEqual()
Returns
Adds a Last 7 Days rule to the range
Declaration
IExcelConditionalFormattingTimePeriodGroup AddLast7Days()
Returns
Adds a Last Month rule to the range
Declaration
IExcelConditionalFormattingTimePeriodGroup AddLastMonth()
Returns
Adds a Last Week rule to the range
Declaration
IExcelConditionalFormattingTimePeriodGroup AddLastWeek()
Returns
Adds a LessThan rule to the range
Declaration
IExcelConditionalFormattingLessThan AddLessThan()
Returns
Adds a LessThanOrEqual rule to the range
Declaration
IExcelConditionalFormattingLessThanOrEqual AddLessThanOrEqual()
Returns
Adds a Next Month rule to the range
Declaration
IExcelConditionalFormattingTimePeriodGroup AddNextMonth()
Returns
Adds a Next Week rule to the range
Declaration
IExcelConditionalFormattingTimePeriodGroup AddNextWeek()
Returns
Adds a NotBetween rule to the range
Declaration
IExcelConditionalFormattingNotBetween AddNotBetween()
Returns
Adds a NotContainsBlanks rule to the range
Declaration
IExcelConditionalFormattingNotContainsBlanks AddNotContainsBlanks()
Returns
Adds a NotContainsErrors rule to the range
Declaration
IExcelConditionalFormattingNotContainsErrors AddNotContainsErrors()
Returns
AddNotContainsText()
Adds a NotContainsText rule to the range
Declaration
IExcelConditionalFormattingNotContainsText AddNotContainsText()
Returns
Adds a NotEqual rule to the range
Declaration
IExcelConditionalFormattingNotEqual AddNotEqual()
Returns
Adds a This Month rule to the range
Declaration
IExcelConditionalFormattingTimePeriodGroup AddThisMonth()
Returns
Adds a This Week rule to the range
Declaration
IExcelConditionalFormattingTimePeriodGroup AddThisWeek()
Returns
Adds a OfficeOpenXml.ConditionalFormatting.ExcelConditionalFormattingThreeColorScale to the range
Declaration
IExcelConditionalFormattingThreeColorScale AddThreeColorScale()
Returns
Declaration
IExcelConditionalFormattingThreeIconSet<eExcelconditionalFormatting3IconsSetType> AddThreeIconSet(eExcelconditionalFormatting3IconsSetType IconSet)
Parameters
Returns
Adds a Today rule to the range
Declaration
IExcelConditionalFormattingTimePeriodGroup AddToday()
Returns
Adds a Tomorrow rule to the range
Declaration
IExcelConditionalFormattingTimePeriodGroup AddTomorrow()
Returns
Adds a Top rule to the range
Declaration
IExcelConditionalFormattingTopBottomGroup AddTop()
Returns
Adds a Top Percent rule to the range
Declaration
IExcelConditionalFormattingTopBottomGroup AddTopPercent()
Returns
Adds a OfficeOpenXml.ConditionalFormatting.ExcelConditionalFormattingTwoColorScale to the range
Declaration
IExcelConditionalFormattingTwoColorScale AddTwoColorScale()
Returns
Adds an UniqueValues rule to the range
Declaration
IExcelConditionalFormattingUniqueValues AddUniqueValues()
Returns
Adds an Yesterday rule to the range
Declaration
IExcelConditionalFormattingTimePeriodGroup AddYesterday()
Returns
Get a list of all conditional formatting rules that exist on cells in the range
Declaration
List<ExcelConditionalFormattingRule> GetConditionalFormattings()
Returns