Apply a Formatting Rule to More than One Cell
It is possible to apply a formatting rule to more than one cell. To do this:
1. In the Conditional Formatting dialog box, double-click a rule to open the Edit Rule dialog box.
2. In the Formatting tab, click on the Format Columns field, and select any additional columns you want to apply the formatting rule to.
3. On applying the change, the additional columns are also highlighted.