Conditional formatting can highlight important data points in a table or crosstab and be used to distinguish values that meet a condition (such as being greater than a certain number or within a specific range).
You can define multiple conditional formatting rules and manage them in the Rules Manager dialog.
In a table with a measure that shows inventory shrinkage at your company’s retail outlets, you could use conditional formatting to identify stores with high rates of shrinkage. A conditional formatting rule could change the cell background color in a shrinkage column to red for each store with shrinkage higher than an amount you specify.
A cell meets the conditions for three conditional formatting rules. The highest-priority active rule sets the font to Times New Roman. The rule with the second highest priority sets the background color to red. A final rule would set the background color to black and the font color to white, but that rule is ignored because it conflicts with the second rule.