Conditional formatting

Conditional formatting is a great tool for displaying color when certain conditions are met. These can be cases when the situation is particularly good or particularly bad, but in either event, the change in color will draw the eye. In this exercise, we will go back to a visual created in a previous exercise and edit it so that a neutral color is used for certain products over a total sales amount threshold but show a different color for products that do not reach the £5,000 total sales amount threshold.

If you have lost any progress, close any open reports and reload 4_4_conditional_formatting.pbix from the Exercises folder on the desktop.