ssml:conditionalFormatting

Conditional Formatting

Element information

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

Schema document: sml-sheet.xsd

Type: ssml:CT_ConditionalFormatting

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:cfRule [1..*] Conditional Formatting Rule
2. ssml:extLst [0..1] Future Feature Storage Area

Attributes

Name	Occ	Type	Description	Notes
pivot	[0..1]	xsd:boolean	PivotTable Conditional Formatting	Default value is "false".
sqref	[0..1]	ssml:ST_Sqref	Sequence of Refernces

Used in

Type ssml:CT_Macrosheet
Type ssml:CT_Worksheet (Element ssml:worksheet)

Sample instance

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