Controlling how multiple rules are applied

Applying a conditional format to your PivotTable lets you emphasize certain…aspects of your data using visual elements.…If you want to format your PivotTable with multiple conditional formats, you…can, and you can control how and when they're applied.…In this movie, I will show you techniques to manage how and when you're…conditional formats are applied. I will use the Multiple sample file, which you…can find in the Chapter05 folder of your Exercise Files archive.…The first thing you need to do is select the cells that contain the formats…you want to work with.…

So, I'll select cells B4 through B8, and then on the Home tab of the ribbon, click…the Conditional Formatting button, and click Manage Rules.…Doing so opens the Conditional Formatting Rules Manager dialog box.…The first rule is the Color Scale that goes from white to yellow;…lowest value to highest value, and the second rule is one that displays any cells…value below 175,000 in red text.…As you can see from cells B5, and B6, both rules are applied.…