ConditionalFormatting element

Contains information about conditional formatting.

Usage

      
<ConditionalFormatting
	Style="xsd:string"
	Style="xsd:string"
/>

    

Element Information

Element type ConditionalFormattingType
Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Child Elements

Element Description
Range Contains the range or a list of ranges that apply to a conditional text format, data validation range, or data source.
Condition Contains a condition and the formatting that is applied to a cell when the condition is true.
Qualifier Contains the qualifier of a condition in conditional text formatting and data validation.
Value1 Contains a text string specifying the value or formula used in conditional text formatting.
Value2 Contains a text string specifying the value or formula used in the second part of conditional text formatting.
Format Specifies the text formatting that is applied to a cell when the condition is true.

Attributes

Attribute Type Required Description Possible Values
Style xsd:string required A text string containing attributes that describe the font weight, style, and effects that are applied when a qualifying condition is true. See external namespace.
Style xsd:string optional A text string containing attributes that describe the font weight, style, and effects that are applied when a qualifying condition is true. See external namespace.

Definition

      
<xsd:element name="ConditionalFormatting" type="ConditionalFormattingType" >
</xsd:element>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp