The FormatAppearances property gives access to a collection of FormatAppearance objects to be displayed on the control's context menu as seen bellow. Each FormatAppearance object contains font or color attributes that can be applied to any column/row on the control's list. If the PivotBarVisible property includes the exPivotBarAllowFormatAppearance flag, the control's context menu includes the FormatAppearance objects. If the exPivotBarAllowFormatAppearance flag is missing from the PivotBarVisible property, the control's context menu displays no FormatAppearance objects.  The Add method adds a new FormatAppearance object to the collection. The FormatConditionalAppearances helps you to provide conditional-format for your data, or in other words, ability to highlight values that matches a specified expression.

The FormatAppearance 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 FormatAppearance objects:

The following screen shot show the control's context menu that contains more FormatAppearance objects