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. The Remove method removes a FormatConditionalAppearance object giving its key. 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.