<xsd:complexType name="ConditionalFormattingType">
<xsd:annotation>
<xsd:documentation>Contains the conditions and the formatting elements that are applied to the specified range when the conditions are true.</xsd:documentation>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="Range" type="xsd:string">
<xsd:annotation>
<xsd:documentation>Contains the range or a list of ranges that apply to a conditional text format, data validation range, or data source.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<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>
</xsd:sequence>
</xsd:complexType>
|
XSD Schema Diagram:
