Playing with conditional styles
Assume that the following report needs to be formatted such that quantities below 1.7 million will be highlighted with red background and those above 2 million should be green. Also, we need the negative values for Running Difference (month-on-month) to be shown in red and in brackets as shown in the following screenshot:
As shown in the previous recipe, this would have needed us to define two conditional variables. Then attach each to the corresponding column as Style variable to define the styles. With one more such numeric column, the author had to define one more variable and repeat the exercise. Let's see how the new conditional styling feature solves this problem.
Getting ready
Write a new report similar to the one shown in the previous screenshot.
How to do it...
In this recipe, we are going to examine more ways to enhance the reports look and feel. To do this:
Select the Quantity column on the report page.
Open the new Conditional Styles dialog box from the...
