ssml:conditionalFormat

Conditional Formatting

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-pivotTable.xsd

Type: ssml:CT_ConditionalFormat

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:pivotAreas [1..1] Pivot Areas
2. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
scope	[0..1]	ssml:ST_Scope	Conditional Formatting Scope	Default value is "selection".
type	[0..1]	ssml:ST_Type	Conditional Formatting Rule Type	Default value is "none".
priority	[1..1]	xsd:unsignedInt	Priority

Used in

Type ssml:CT_ConditionalFormats (Element ssml:conditionalFormats)

Sample instance

<ssml:conditionalFormat priority="1">
   <ssml:pivotAreas>
      <ssml:pivotArea>
         <ssml:references>...
         </ssml:references>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:pivotArea>
   </ssml:pivotAreas>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:conditionalFormat>