FormatConditionalAppearance object

The FormatConditionalAppearance objects can be accessed through the control's FormatConditionalAppearances property. The Expression property defines the conditional expression that determines whether the current format is applied on the pivot's cell based on the cell's value. The FormatConditionalAppearance object changes the visual appearance of your data as listed:

 The following screen shot shows the control's context menu with the FormatConditionalAppearance objects:

The FormatConditionalAppearance object supports the following properties and methods:

 NameDescription 
  BackColorSpecifies the element's background color. 
  BoldRenders as bold text. 
  ContextEditExpressionIndicates whether the item of the current conditional-format object in the control's content menu displays/edits the conditional expression, at runtime. 
  ExpressionSpecifies the conditional expression that determines whether the current format is applied on the pivot's data. 
  FontRetrieves or sets the text's font. 
  FontSizeIndicates the size of the font to display the text. 
  ForeColorSpecifies the element's foreground color. 
  GradientRenders the text with a gradient color. 
  GradientModeIndicates the gradient mode to be applied on text. 
  ItalicRenders as italic text. 
  KeyIndicates the key of the FormatConditionalAppearance object. 
  NameSpecifies the name of the FormatConditionalAppearance object to be displayed on the context menu. 
  OutlineRenders the text outlined with specified color. 
  OutlineSizeIndicates the size of the outline to be applied on text. 
  ShadowRenders the text with a shadow of specified color. 
  ShadowOffsetIndicates the offset of the shadow to be applied on text. 
  ShadowSizeIndicates the size of the shadow to be applied on text. 
  StrikeOutSpecifies that the text should appear as strikeout. 
  ToolTipSpecifies the tooltip of the FormatConditionalAppearance object to be displayed when the cursor hovers the object. 
  UnderlineUnderlines the text.