Conditional 3-Color Scale macro applies a two-step color gradient to the specified range of cells, using a minimum, a midpoint and a maximum color. This macro must be used inside Conditional Rules Manager macro.

New! Datacenter Only

Conditional 3-Color Scale macro does the following:

  1. sets Minimum value color for the cells, which values are lower than the ones, defined by the Minimum value type and Minimum value parameters;
  2. sets Midpoint value color for the cells, which values are equal to the ones, defined by the Midpoint value type and Midpoint value parameters;
  3. sets Maximum value color for the cells, which values are higher than the ones, defined by the Maximum value type and Maximum value parameters;
  4. sets the gradient colors for the values between minimum and midpoint, and between midpoint and maximum, accordingly.

 

Conditional 3-Color Scale macro has the following parameters:

Parameter Description
[Enum] Minimum value type (default='Lowest value') The type of the minimum value to be used. Based on this type Minimum value parameter value may have to be specified. May have one of the following values:
  • Lowest value
    • Means, that the minimum value of all the values in the range should be used
    • If Minimum value type is “Lowest value”, the Minimum value parameter value is ignored
  • Number
    • Means, that the specified number should be used
    • In this case the number should be specified as Minimum value parameter value
  • Percent
    • Means, that the value, which is the minimum of all the values in the range plus the difference between maximum and minimum value multiplied by the number of percents should be used
    • The number of percents is specified in Minimum value parameter
[String] Minimum value (default=empty) The value parameter – either constant or percent value should be specified, based on the Minimum value type parameter value.
[String] Minimum value color (default='red') The color to be used for the values below the Minimum value and as the starting color for the gradient. Standard CSS color names, Confluence highlight color names and colors in HEX notation (#rrggbb) are supported.
[Enum] Midpoint value type (default='Percentile') The type of the midpoint value to be used. Based on this type Midpoint value parameter value may have to be specified. May have one of the following values:
  • Percentile
    • Means, that the value at the specified percentile of all the values in the range should be used
    • The percentile (0–100) is specified in Midpoint value parameter; the default is 50 (the median)
  • Number
    • Means, that the specified number should be used
    • In this case the number should be specified as Midpoint value parameter value
  • Percent
    • Means, that the value, which is the minimum of all the values in the range plus the difference between maximum and minimum value multiplied by the number of percents should be used
    • The number of percents is specified in Midpoint value parameter
[String] Midpoint value (default='50') The value parameter – either a percentile, a constant or a percent value should be specified, based on the Midpoint value type parameter value.
[String] Midpoint value color (default='yellow') The color to be used for the values at the Midpoint value and as the middle color for the gradient. Standard CSS color names, Confluence highlight color names and colors in HEX notation (#rrggbb) are supported.
[Enum] Maximum value type (default='Highest value') The type of the maximum value to be used. Based on this type Maximum value parameter value may have to be specified. May have one of the following values:
  • Highest value
    • Means, that the maximum value of all the values in the range should be used
    • If Maximum value type is “Highest value”, the Maximum value parameter value is ignored
  • Number
    • Means, that the specified number should be used
    • In this case the number should be specified as Maximum value parameter value
  • Percent
    • Means, that the value, which is the maximum of all the values in the range plus the difference between maximum and minimum value multiplied by the number of percents should be used
    • The number of percents is specified in Maximum value parameter
[String] Maximum value (default=empty) The value parameter – either constant or percent value should be specified, based on the Maximum value type parameter value.
[String] Maximum value color (default='green') The color to be used for the values above the Maximum value and as the ending color for the gradient. Standard CSS color names, Confluence highlight color names and colors in HEX notation (#rrggbb) are supported.
[String] Applies to (default='All tables') Specifies the cells to apply conditional formatting to.
  • Set to 'All tables' to apply formatting to all cells of all tables.
  • An exact column range may be specified to apply formatting to the specified columns only. Note, that exact Table specificator should also be specified. Example: 'Table1.A:B'.
  • Several ranges may be specified, separated with ';' symbol. Example: 'Table1.A:B; Table1.D:E'.

When the parameters are set, an example of the gradient from Minimum value color through Midpoint value color up to the Maximum value color may be seen at the preview pane of the macro editor. Press “Preview” button after changing parameters to see the gradient.