Format Rule: Gradient Ranges

“Gradient Ranges” allow you to use predefined color gradients to apply conditional formatting to different ranges of values. You can also use specific colors to generate custom gradients.:

The form of the gradient highlight looks the following:

The following options will be available in the appeared window:

• Number of ranges – “Number of ranges” allows you to specify the number of ranges used to classify values. Click the “Generate Ranges” button to generate a new gradient scale according to the specified number of ranges;
• Use % ranges – the “Use % ranges” check box specifies whether the percent or absolute scale is used to generate ranges;

• Range field with specified ranges:
• Intersection mode – the level at which the highlight will be The levels can be as follows:
  • Auto – identifies the default For the Pivot dashboard item, Auto identifies the “First Level”;
  • First level – first level values are used to apply conditional formatting;
  • Last level – the last level values are used to apply conditional formatting;
  • All levels – all pivot data cells are used to apply conditional formatting;
  • Specific level – values from the specific level are used to apply conditional
• Row/Column dimension – if you specified the Intersection mode as “Specific Level”, use the “Row dimension” and “Column dimension” combo boxes to set the specific level;
• Apply to – to which element (measure, hierarchy) of the Pivot table the conditional formatting should be applied;

Apply to row/column – apply to the entire row / to the entire column.