Exposes properties which control the visual attributes of a based on whether the cell's value meets the criteria defined by a logical operator.
Inheritance
Properties
Section titled "Properties"CellFormat
Section titled "CellFormat"Inherited from: ConditionalFormatBase
Returns an interface implementation which represents the format for cells which meet the criteria associated with this condition.
public IWorksheetCellFormat CellFormat { get; }Worksheet
Section titled "Worksheet"Inherited from: ConditionBase
Returns a reference to the associated worksheet.
public Worksheet Worksheet { get; }Workbook
Section titled "Workbook"Inherited from: ConditionBase
Returns a reference to the associated workbook.
public Workbook Workbook { get; }Regions
Section titled "Regions"Inherited from: ConditionBase
Returns the which identifies the cell range with which this condition is associated.
public ReadOnlyCollection<WorksheetRegion> Regions { get; }ConditionType
Section titled "ConditionType"Inherited from: ConditionBase
Returns a value which identifies the type of condition for this instance.
public FormatConditionType ConditionType { get; }Priority
Section titled "Priority"Inherited from: ConditionBase
Returns or sets a value which determines the order of evaluation when multiple conditional formatting rules exist.
public int Priority { get; set; }StopIfTrue
Section titled "StopIfTrue"Inherited from: ConditionBase
Returns or sets a boolean indicating whether additional formatting rules are evaluated if this rule evaluates to true. Applicable only in the case where the containing contains more than one element.
public bool StopIfTrue { get; set; }Operand1
Section titled "Operand1"Returns the which defines the criteria for the first operand of this condition.
public Formula Operand1 { get; }Operand2
Section titled "Operand2"Returns or sets a for the second operand which defines the criteria for this condition when the property is set to Between or NotBetween
public Formula Operand2 { get; }Operator
Section titled "Operator"Returns a constant which determines the manner in which the cell value is compared against the property.
public FormatConditionOperator Operator { get; set; }Methods
Section titled "Methods"SetFirstPriority()
Section titled "SetFirstPriority()"Inherited from: ConditionBase
Sets the value for this rule such that it is the first condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated .
public void SetFirstPriority()Returns any
SetLastPriority()
Section titled "SetLastPriority()"Inherited from: ConditionBase
Sets the value for this rule such that it is the last condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated .
public void SetLastPriority()Returns any
SetRegions(string, CellReferenceMode?)
Section titled "SetRegions(string, CellReferenceMode?)"Inherited from: ConditionBase
Replaces the existing regions with new ones
public void SetRegions(string regionAddress, CellReferenceMode? cellReferenceMode)Parameters
- regionAddress:
string - cellReferenceMode:
CellReferenceMode?
Returns any
SetOperand1(DateTime)
Section titled "SetOperand1(DateTime)"Assigns the specified System.DateTime value to the property.
public void SetOperand1(DateTime value)Parameters
- value:
DateTime
Returns any
SetOperand1(double)
Section titled "SetOperand1(double)"Assigns the specified System.Double value to the property.
public void SetOperand1(double value)Parameters
- value:
double
Returns any
SetOperand1(string)
Section titled "SetOperand1(string)"Assigns the specified System.String value to the property.
public void SetOperand1(string value)Parameters
- value:
string
Returns any
SetOperand1Formula(string, CellReferenceMode?)
Section titled "SetOperand1Formula(string, CellReferenceMode?)"Assigns a to the property.
public void SetOperand1Formula(string formula, CellReferenceMode? cellReferenceMode = null)Parameters
- formula:
string - cellReferenceMode:
CellReferenceMode?
Returns any
SetOperand2(DateTime)
Section titled "SetOperand2(DateTime)"Assigns the specified System.DateTime value to the property.
public void SetOperand2(DateTime value)Parameters
- value:
DateTime
Returns any
SetOperand2(double)
Section titled "SetOperand2(double)"Assigns the specified System.Double value to the property.
public void SetOperand2(double value)Parameters
- value:
double
Returns any
SetOperand2(string)
Section titled "SetOperand2(string)"Assigns the specified System.String value to the property.
public void SetOperand2(string value)Parameters
- value:
string
Returns any
SetOperand2Formula(string, CellReferenceMode?)
Section titled "SetOperand2Formula(string, CellReferenceMode?)"Assigns a to the property.
public void SetOperand2Formula(string formula, CellReferenceMode? cellReferenceMode = null)Parameters
- formula:
string - cellReferenceMode:
CellReferenceMode?