Creating a Conditional Color Palette in a Chart
You can create a conditional palette to color data items
in your chart in different ways depending on a condition. For example,
in a column chart that shows revenue per month, you want to make the
columns for the months that have a revenue greater than $1000000 green.
You can also use conditional styles to highlight exceptional data and use conditions to control the layout of your report.