excel.interfaces.conditionalformatruleloadoptions.yml

### YamlMime:TSType
name: Excel.Interfaces.ConditionalFormatRuleLoadOptions
uid: 'excel!Excel.Interfaces.ConditionalFormatRuleLoadOptions:interface'
package: excel!
fullName: Excel.Interfaces.ConditionalFormatRuleLoadOptions
summary: 'Represents a rule, for all traditional rule/format pairings.'
remarks: '\[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: $all
    uid: 'excel!Excel.Interfaces.ConditionalFormatRuleLoadOptions#$all:member'
    package: excel!
    fullName: $all
    summary: >-
      Specifying `$all` for the LoadOptions loads all the scalar properties (e.g.: `Range.address`<!-- -->) but not the
      navigational properties (e.g.: `Range.format.fill.color`<!-- -->).
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: '$all?: boolean;'
      return:
        type: boolean
  - name: formula
    uid: 'excel!Excel.Interfaces.ConditionalFormatRuleLoadOptions#formula:member'
    package: excel!
    fullName: formula
    summary: 'The formula, if required, on which to evaluate the conditional format rule.'
    remarks: '\[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'formula?: boolean;'
      return:
        type: boolean
  - name: formulaLocal
    uid: 'excel!Excel.Interfaces.ConditionalFormatRuleLoadOptions#formulaLocal:member'
    package: excel!
    fullName: formulaLocal
    summary: 'The formula, if required, on which to evaluate the conditional format rule in the user''s language.'
    remarks: '\[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'formulaLocal?: boolean;'
      return:
        type: boolean
  - name: formulaR1C1
    uid: 'excel!Excel.Interfaces.ConditionalFormatRuleLoadOptions#formulaR1C1:member'
    package: excel!
    fullName: formulaR1C1
    summary: 'The formula, if required, on which to evaluate the conditional format rule in R1C1-style notation.'
    remarks: '\[ [API set: ExcelApi 1.6](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'formulaR1C1?: boolean;'
      return:
        type: boolean