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]
- ssml:pivotAreas [1..1] Pivot Areas
- 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>