Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: Element
Name: Condition
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
MinOccurs (1)
MaxOccurs 3
Abstract
Documentation:
Contains a condition and the formatting that is applied to a cell when the condition is true.
Collapse XSD Schema Diagram:
Drilldown into Format in schema excel_xsd Drilldown into Value2 in schema excel_xsd Drilldown into Value1 in schema excel_xsd Drilldown into Qualifier in schema excel_xsd Drilldown into Style in schema excel_xsdXSD Diagram of Condition in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:element name="Condition" maxOccurs="3">
    <xsd:annotation>
        <xsd:documentation>Contains a condition and the formatting that is applied to a cell when the condition is true.</xsd:documentation>
    </xsd:annotation>
    <xsd:complexType>
        <xsd:sequence>
            <xsd:element name="Qualifier" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains the qualifier of a condition in conditional text formatting and data validation.</xsd:documentation>
                </xsd:annotation>
                <xsd:simpleType>
                    <xsd:restriction base="xsd:string">
                        <xsd:enumeration value="Between" />
                        <xsd:enumeration value="NotBetween" />
                        <xsd:enumeration value="Equal" />
                        <xsd:enumeration value="NotEqual" />
                        <xsd:enumeration value="Greater" />
                        <xsd:enumeration value="Less" />
                        <xsd:enumeration value="GreaterOrEqual" />
                        <xsd:enumeration value="LessOrEqual" />
                    </xsd:restriction>
                </xsd:simpleType>
            </xsd:element>
            <xsd:element name="Value1" type="xsd:string">
                <xsd:annotation>
                    <xsd:documentation>Contains a text string specifying the value or formula used in conditional text formatting.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Value2" type="xsd:string" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains a text string specifying the value or formula used in the second part of conditional text formatting.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Format" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies the text formatting that is applied to a cell when the condition is true.</xsd:documentation>
                </xsd:annotation>
                <xsd:complexType>
                    <xsd:attribute name="Style" type="xsd:string" use="required">
                        <xsd:annotation>
                            <xsd:documentation>A text string containing attributes that describe the font weight, style, and effects that are applied when a qualifying condition is true.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:attribute>
                </xsd:complexType>
            </xsd:element>
        </xsd:sequence>
        <xsd:attribute name="Style" type="xsd:string" use="optional">
            <xsd:annotation>
                <xsd:documentation>A text string containing attributes that describe the font weight, style, and effects that are applied when a qualifying condition is true.</xsd:documentation>
            </xsd:annotation>
        </xsd:attribute>
    </xsd:complexType>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Qualifier x:Qualifier 0 (1)
Value1 x:Value1 (1) (1)
Value2 x:Value2 0 (1)
Format x:Format 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
Style x:Style Optional
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0