L.2.2.14 Conditional Formatting

L.2.2 Sheets

<conditionalFormatting sqref="H6:H11">
  <cfRule type="dataBar" priority="3" stopIfTrue="0">
    <formula>MAX(IF(ISBLANK(H6:H11), "", IF(ISERROR(H6:H11), "",
      H6:H11)))</formula>
    <formula>MIN(IF(ISBLANK(H6:H11), "", IF(ISERROR(H6:H11), "",
      H6:H11)))</formula>
    <dataBar minLength="10" maxLength="90" showValue="1">
      <cfvo type="min" val="0"/>
      <cfvo type="max" val="0"/>
      <color rgb="FF63C384"/>
    </dataBar>
  </cfRule>
</conditionalFormatting>
<conditionalFormatting sqref="G6:G11">
  <cfRule type="cellIs" dxfId="0" priority="1" stopIfTrue="0"
operator="greaterThan">
    <formula>0.5</formula>
  </cfRule>
</conditionalFormatting>

There are two conditional formats applied: one to the table of data in column H and the other to the table of data in column G.

In column G, a red fill is applied to any cell whose value is greater than 0.5. Notice that sqref specifies the range to which the rule applies. The formatting is specified by dxfId, which is a reference to a formatting expression in the central styles part.

In column H there is a dataBar formatting rule, which applies a variable length bar to the cell background, where the length of the bar depends on the relative value of the cell.

Last updated on March 14, 2025

L.2.12.14 Connection XML