Version

Search Results

SetLastPriority Method

Sets the Priority 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 ConditionalFormatCollection. Syntax Remarks Just as the SetFirstPriority method ensures that the associated condition is evalula...

SetRegions Method

Replaces the existing regions with new ones Syntax Parameters regionAddress A string with one or more comma separated region addresscellReferenceMode An optional cell reference mode Exceptions Exception Description System.ArgumentException If regionAddress is invalid or contains a region from another worksheet

StopIfTrue Property

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 collection contains more than one element. Syntax Remarks If a cell value meets more than one condition, the format defined by the first condition ...

Workbook Property (ConditionBase)

Returns a reference to the associated workbook. Syntax

Worksheet Property (ConditionBase)

Returns a reference to the associated worksheet. Syntax

ConditionValue Class

Exposes properties which define the value and its unit of measure for a conditional format threshold. Syntax Remarks When the ValueType property is set to Number, Percentage, or Percentile, only the Value property is applicable. Similarly, the Formula property is only applicable whenValueType is set to Formula. Fo...

ConditionValue Class Events

For a list of all members of this type, see ConditionValue members. Public Events Name Description PropertyChanged Occurs after a property value has changed Top

ConditionValue Class Members

Public Properties Public Methods Public Events