Worksheet.EnableFormatConditionsCalculation Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets or sets a value that determines whether conditional formats will occur automatically.
public:
property bool EnableFormatConditionsCalculation { bool get(); void set(bool value); };public bool EnableFormatConditionsCalculation { get; set; }member this.EnableFormatConditionsCalculation : bool with get, setPublic Property EnableFormatConditionsCalculation As BooleanProperty Value
true if evaluation of conditional formats will occur automatically; otherwise, false. The default is true.
Remarks
When the EnableFormatConditionsCalculation property is set to false, existing conditional formats will not be re-evaluated. Any previously applied conditional formatting will still be visible, but will not be updated as cell values or AppliesTo ranges are changed.
Set this property to true to configure a rule completely before evaluating it. This can result in a performance increase if the range over which the condition is applied is large.