excel.interfaces.iconsetconditionalformatupdatedata.yml

### YamlMime:TSType
name: Excel.Interfaces.IconSetConditionalFormatUpdateData
uid: 'excel!Excel.Interfaces.IconSetConditionalFormatUpdateData:interface'
package: excel!
fullName: Excel.Interfaces.IconSetConditionalFormatUpdateData
summary: >-
  An interface for updating data on the IconSetConditionalFormat object, for use in `iconSetConditionalFormat.set({ ...
  })`<!-- -->.
remarks: ''
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: criteria
    uid: 'excel!Excel.Interfaces.IconSetConditionalFormatUpdateData#criteria:member'
    package: excel!
    fullName: criteria
    summary: >-
      An array of criteria and icon sets for the rules and potential custom icons for conditional icons. Note that for
      the first criterion only the custom icon can be modified, while type, formula, and operator will be ignored when
      set.
    remarks: '\[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'criteria?: Excel.ConditionalIconCriterion[];'
      return:
        type: '<xref uid="excel!Excel.ConditionalIconCriterion:interface" />[]'
  - name: reverseIconOrder
    uid: 'excel!Excel.Interfaces.IconSetConditionalFormatUpdateData#reverseIconOrder:member'
    package: excel!
    fullName: reverseIconOrder
    summary: >-
      If `true`<!-- -->, reverses the icon orders for the icon set. Note that this cannot be set if custom icons are
      used.
    remarks: '\[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'reverseIconOrder?: boolean;'
      return:
        type: boolean
  - name: showIconOnly
    uid: 'excel!Excel.Interfaces.IconSetConditionalFormatUpdateData#showIconOnly:member'
    package: excel!
    fullName: showIconOnly
    summary: 'If `true`<!-- -->, hides the values and only shows icons.'
    remarks: '\[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'showIconOnly?: boolean;'
      return:
        type: boolean
  - name: style
    uid: 'excel!Excel.Interfaces.IconSetConditionalFormatUpdateData#style:member'
    package: excel!
    fullName: style
    summary: 'If set, displays the icon set option for the conditional format.'
    remarks: '\[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: >-
        style?: Excel.IconSet | "Invalid" | "ThreeArrows" | "ThreeArrowsGray" | "ThreeFlags" | "ThreeTrafficLights1" |
        "ThreeTrafficLights2" | "ThreeSigns" | "ThreeSymbols" | "ThreeSymbols2" | "FourArrows" | "FourArrowsGray" |
        "FourRedToBlack" | "FourRating" | "FourTrafficLights" | "FiveArrows" | "FiveArrowsGray" | "FiveRating" |
        "FiveQuarters" | "ThreeStars" | "ThreeTriangles" | "FiveBoxes";
      return:
        type: >-
          <xref uid="excel!Excel.IconSet:enum" /> | "Invalid" | "ThreeArrows" | "ThreeArrowsGray" | "ThreeFlags" |
          "ThreeTrafficLights1" | "ThreeTrafficLights2" | "ThreeSigns" | "ThreeSymbols" | "ThreeSymbols2" | "FourArrows"
          | "FourArrowsGray" | "FourRedToBlack" | "FourRating" | "FourTrafficLights" | "FiveArrows" | "FiveArrowsGray" |
          "FiveRating" | "FiveQuarters" | "ThreeStars" | "ThreeTriangles" | "FiveBoxes"