You can create up to three conditional formatting rules for a single column, evaluated in the order in which they appear in the list of rules. You can, for example, create three rules to set the values of a profit column to one of three colors, depending on the dollar amount. Figure 6‑11 shows an example. When creating multiple rules for a column, be careful that the conditions do not cover overlapping values.