ssml:cfRule

Conditional Formatting Rule

Element information

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

Schema document: sml-sheet.xsd

Type: ssml:CT_CfRule

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:formula [0..3] Formula
2. ssml:colorScale [0..1] Color Scale
3. ssml:dataBar [0..1] Data Bar
4. ssml:iconSet [0..1] Icon Set
5. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
type	[0..1]	ssml:ST_CfType	Type
dxfId	[0..1]	ssml:ST_DxfId	Differential Formatting Id
priority	[1..1]	xsd:int	Priority
stopIfTrue	[0..1]	xsd:boolean	Stop If True	Default value is "false".
aboveAverage	[0..1]	xsd:boolean	Above Or Below Average	Default value is "true".
percent	[0..1]	xsd:boolean	Top 10 Percent	Default value is "false".
bottom	[0..1]	xsd:boolean	Bottom N	Default value is "false".
operator	[0..1]	ssml:ST_ConditionalFormattingOperator	Operator
text	[0..1]	xsd:string	Text
timePeriod	[0..1]	ssml:ST_TimePeriod	Time Period
rank	[0..1]	xsd:unsignedInt	Rank
stdDev	[0..1]	xsd:int	StdDev
equalAverage	[0..1]	xsd:boolean	Equal Average	Default value is "false".

Used in

Type ssml:CT_ConditionalFormatting (Element ssml:conditionalFormatting)

Sample instance

<ssml:cfRule priority="1">
   <ssml:formula>string</ssml:formula>
   <ssml:colorScale>
      <ssml:cfvo type="num" val="string">
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:cfvo>
      <ssml:color/>
   </ssml:colorScale>
   <ssml:dataBar>
      <ssml:cfvo type="num" val="string">
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:cfvo>
      <ssml:color/>
   </ssml:dataBar>
   <ssml:iconSet iconSet="3TrafficLights1">
      <ssml:cfvo type="num" val="string">
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:cfvo>
   </ssml:iconSet>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:cfRule>