method FormatConditionalAppearances.Remove (Key as Variant)
Removes a specific member from the collection.

TypeDescription
Key as Variant A String expression that indicates the Key of the FormatConditionalAppearance object to be removed.
The Remove method removes a FormatConditionalAppearance object giving its key. The Clear method removes all elements in the FormatConditionalAppearances collection. Excludes the exPivotBarAllowFormatConditionalAppearance flag from the PivotBarVisible property, and so no FormatConditionalAppearance objects are displayed on the control's context menu. Use the Add method to add a new FormatConditionalAppearance object. You can use the for each statement to enumerate all objects in the FormatConditionalAppearances collection.