Conditional 2-Color Scale macro applies color gradient to the specified range of cells. This macro must be used inside Conditional Rules Manager macro.

Conditional 2-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 Maximum value color for the cells, which values are higher than the ones, defined by the Maximum value type and Maximum value parameters;
  3. sets the gradient colors for the values between minimum and maximum accordingly.

 

Conditional 2-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. I.e. in this case we specify, that specified number of percents from the minimum value down to the minimum value should be colored with Minimum value color
    • 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='white') 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] 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. I.e. in this case we specify, that (100 – percents) from the Maximum value up to the maximum should be colored with Maximum value color
    • 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='white') 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 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.