Interface IRangeConditionalFormatting
Provides functionality for adding Conditional Formatting to a range (ExcelRangeBase).
Each method will return a configurable condtional formatting type.
Assembly: Experior.Core.dll
public interface IRangeConditionalFormatting
Methods
Adds a Above Average rule to the range
Declaration
IExcelConditionalFormattingAverageGroup AddAboveAverage()
Returns
Adds a Above Or Equal Average rule to the range
Declaration
IExcelConditionalFormattingAverageGroup AddAboveOrEqualAverage()
Returns
Adds a 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 a 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 a EndsWith rule to the range
Declaration
IExcelConditionalFormattingEndsWith AddEndsWith()
Returns
Adds a Equal rule to the range
Declaration
IExcelConditionalFormattingEqual AddEqual()
Returns
Adds a 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
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
Declaration
IExcelConditionalFormattingTwoColorScale AddTwoColorScale()
Returns
Adds a UniqueValues rule to the range
Declaration
IExcelConditionalFormattingUniqueValues AddUniqueValues()
Returns
Adds a Yesterday rule to the range
Declaration
IExcelConditionalFormattingTimePeriodGroup AddYesterday()
Returns