41722

Conditional formatting as saved by Calc

<conditionalFormatting sqref="A1:A3">
   <cfRule type="containsText" priority="2" aboveAverage="0" equalAverage="0" bottom="0" percent="0" rank="0" text="a" dxfId="0" />
   <cfRule type="containsText" priority="3" aboveAverage="0" equalAverage="0" bottom="0" percent="0" rank="0" text="b" dxfId="1" />
   <cfRule type="containsText" priority="4" aboveAverage="0" equalAverage="0" bottom="0" percent="0" rank="0" text="c" dxfId="2" />
</conditionalFormatting>

Conditional formatting as saved by Excel

<conditionalFormatting sqref="A1:A3">
   <cfRule type="containsText" dxfId="5" priority="2" operator="containsText" text="a">
      <formula>NOT(ISERROR(SEARCH("a",A1)))</formula>
   </cfRule>
   <cfRule type="containsText" dxfId="4" priority="3" operator="containsText" text="b">
      <formula>NOT(ISERROR(SEARCH("b",A1)))</formula>
   </cfRule>
   <cfRule type="containsText" dxfId="3" priority="4" operator="containsText" text="c">
      <formula>NOT(ISERROR(SEARCH("c",A1)))</formula>
   </cfRule>
</conditionalFormatting>