Conditional Formatting
<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.