Schema Central > OOXML > sml-sheet.xsd > ssml:cfRule
Advanced search
Need XML Help?

Recommended Reading:

Definitive XML Schema


Web Service Contract Design and Versioning for SOA


Advanced XML Applications



Conditional Formatting Rule

Element information

Type: ssml:CT_CfRule

Properties: Local, Qualified



type [0..1]ssml:ST_CfTypeType
dxfId [0..1]ssml:ST_DxfIdDifferential Formatting Id
priority [1..1]xsd:intPriority
stopIfTrue [0..1]xsd:booleanStop If TrueDefault value is "false".
aboveAverage [0..1]xsd:booleanAbove Or Below AverageDefault value is "true".
percent [0..1]xsd:booleanTop 10 PercentDefault value is "false".
bottom [0..1]xsd:booleanBottom NDefault value is "false".
operator [0..1]ssml:ST_ConditionalFormattingOperatorOperator
text [0..1]xsd:stringText
timePeriod [0..1]ssml:ST_TimePeriodTime Period
rank [0..1]xsd:unsignedIntRank
stdDev [0..1]xsd:intStdDev
equalAverage [0..1]xsd:booleanEqual AverageDefault value is "false".

Used in

Sample instance

<ssml:cfRule priority="1">
      <ssml:cfvo type="num" val="string">
      <ssml:cfvo type="num" val="string">
   <ssml:iconSet iconSet="3TrafficLights1">
      <ssml:cfvo type="num" val="string">
         <!--any element-->

Site developed and hosted by Datypic, Inc.

Please report errors or comments about this site to