Condition


  • Mode
    A condition that needs to be met for the conditional style to apply.

    • Equal To
      The condition value equals to the current value.

    • Not Equal To
      The condition value does not equal to the current value.

    • Contains
      Available only for string values
      Case insensitive
      The current value contains the condition value. If multiple words are used, values that contain all words in any order are displayed.

    • Begins With
      Available only for string values
      Case insensitive
      The current value begins with the condition value.

    • Ends With
      Available only for string values
      Case insensitive
      The current value ends with the condition value.

    • Matches RegEx
      Available only for string values
      The current value matches the condition value in terms of a Javascript Regex.

    • Greater Than
      Available only for numeric values
      The current value is greater than the condition value.

    • Greater Than or Equal To
      Available only for numeric values
      The current value is greater than or equals to the condition value.

    • Less Than
      Available only for numeric values
      The current value is less than the condition value.

    • Less Than or Equal To
      Available only for numeric values
      The current value is less than or equals to the condition value.

    • Between
      Available only for numeric values
      The current value is in the range of values, defined by selecting the Min and Max value. The range can contain also the Min or Max value by choosing one or both of the options.

    • Not Between
      Available only for numeric values
      The current value is outside the range of values, defined by selecting the Min and Max value. The range can contain also the Min or Max value by choosing one or both of the options.

    • In Set
      The current value matches one of the defined condition values.

    • Not in Set
      The current value does not match any of the defined condition values.

    • Has Value
      The current value is available.

    • No Value
      The current value is not available.

  • Value
    A value for the condition to be met.

  • Pattern
    Available only when “Matches” Mode is selected
    A Javascript Regex pattern for the current value to match to trigger the conditional style.

  • Include Min Value
    Available only when “Between” or “Not Between” Mode is selected
    Whether the range defined by the Min and Max value should also include a Min value.

  • Min Value
    Available only when “Between” or “Not Between” Mode is selected
    The Minimum value of the range, for which the conditional style applies.

  • Include Max Value
    Available only when “Between” or “Not Between” Mode is selected
    Whether the range defined by the Min and Max value should also include a Max value.

  • Max Value
    Available only when “Between” or “Not Between” Mode is selected
    The Maximum value of the range, for which the conditional style applies.

  • Set Values
    Available only when “In Set” or “Not In Set” Mode is selected
    The current value must (In Set mode) or must not (Not in Set mode) be present in list of values to trigger the conditional style.

    • Value
      A value for the condition to be met.