The FormatConditionalAppearances property gives access to a collection of FormatConditionalAppearance objects to be displayed on the control's context menu as seen bellow. Each FormatConditionalAppearance object contains font or color attributes that can be applied to any column/row on the control's list, based on an expression. If the PivotBarVisible property includes the exPivotBarAllowFormatConditionalAppearance flag, the control's context menu includes the FormatConditionalAppearance objects. If the exPivotBarAllowFormatConditionalAppearance flag is missing from the PivotBarVisible property, the control's context menu displays no FormatConditonalAppearance objects.  The Add method adds a new FormatConditionalAppearance object to the collection. Use the FormatAppearances property to add support for format the entire column of the pivot table.

The FormatCondtionalAppearance object changes the visual appearance of your data as listed:

• font attributes, like bold, italic,...
• different foreground colors
• different background colors, including the ability to show EBN objects

 By default, the control's context menu displays the following FormatConditionalAppearance objects: