Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: Element
Name: cfRule
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Type: nsM:CT_CfRule
Containing Schema: sml-sheet.xsd
MinOccurs 1
MaxOccurs unbounded
Abstract
Documentation:
Conditional Formatting Rule
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-sheet_xsd Drilldown into iconSet in schema sml-sheet_xsd Drilldown into dataBar in schema sml-sheet_xsd Drilldown into colorScale in schema sml-sheet_xsd Drilldown into formula in schema sml-sheet_xsd Drilldown into equalAverage in schema sml-sheet_xsd Drilldown into stdDev in schema sml-sheet_xsd Drilldown into rank in schema sml-sheet_xsd Drilldown into timePeriod in schema sml-sheet_xsd Drilldown into text in schema sml-sheet_xsd Drilldown into operator in schema sml-sheet_xsd Drilldown into bottom in schema sml-sheet_xsd Drilldown into percent in schema sml-sheet_xsd Drilldown into aboveAverage in schema sml-sheet_xsd Drilldown into stopIfTrue in schema sml-sheet_xsd Drilldown into priority in schema sml-sheet_xsd Drilldown into dxfId in schema sml-sheet_xsd Drilldown into type in schema sml-sheet_xsd Drilldown into CT_CfRule in schema sml-sheet_xsdXSD Diagram of cfRule in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:element name="cfRule" type="CT_CfRule" minOccurs="1" maxOccurs="unbounded">
    <xsd:annotation>
        <xsd:documentation>Conditional Formatting Rule</xsd:documentation>
    </xsd:annotation>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
formula nsM:formula 0 3
colorScale nsM:colorScale 0 1
dataBar nsM:dataBar 0 1
iconSet nsM:iconSet 0 1
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
type nsM:type (Optional)
dxfId nsM:dxfId Optional
priority nsM:priority Required
stopIfTrue nsM:stopIfTrue false Optional
aboveAverage nsM:aboveAverage true Optional
percent nsM:percent false Optional
bottom nsM:bottom false Optional
operator nsM:operator Optional
text nsM:text Optional
timePeriod nsM:timePeriod Optional
rank nsM:rank Optional
stdDev nsM:stdDev Optional
equalAverage nsM:equalAverage false Optional
Collapse Derivation Tree:
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0