Value can be one of the highlight rules: Let us have a look at it on an example of the pivot table: Let us select the totals of those product categories for which the values of the “Sales Amount” measure are more than $ 1 million: The following form appears: This form contains the following […]

The “Top-Bottom” format conditions allow you to highlight a specific number of topmost/bottommost values. You can specify this number as an absolute or percent value: For example, let us select 4 quarters for which the “Sales Amount” measure values were the worst. Select the type of “Bottom N” highlight and fill out the form as […]

The “Average” format conditions allow you to highlight values above or below an average:

An “Expression” format condition allows you to use complex conditions to apply formatting:

Icon “Ranges” allow you to use predefined or custom sets of icons to apply conditional formatting to different ranges of values: For example, let us select the 4-range highlight for the “Gross Profit” measure: The following options are available in the appeared window: Format style – the “Format Style” combo box allows you to change […]

To format values according to the required condition, click the data item menu button, select “Add Format Rule”| “Color Ranges” and choose the required color set: The working principle is the same as for the “Format Rule: Icon Ranges” highlight rule:

“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 […]

The “Bar” format condition allows you to visualize numeric values using bars. You can also paint bars corresponding to positive and negative values using different colors: This dialog allows you to change the following options specific to the “Bar” format condition: Min/Max – by default, lengths of the shortest and longest bars correspond to minimum […]

“Bar Color Ranges” allow you to visualize numeric values using bars whose colors are contained in the specified color set: This dialog allows you to change the following options specific to “Bar Color Ranges”: The following options will be available in the appeared window: Format style – the “Format Style” combo box allows you to […]

Bar Gradient Ranges allow you to visualize numeric values using bars whose colors are contained in the specified color gradient: This dialog allows you to change the following options specific to “Bar Gradient Ranges”: Number of ranges – “Number of ranges” allows you to specify the number of ranges used to classify Click the Generate […]