Apply Multiple Conditional Formats to the Same Cell(s) in Ms Excel
To apply more than one conditional formatting rule to the same cells, select the cells, and then apply each new rule that you need. However, to prioritize the rules for the exact result you want, use the Conditional Formatting Rules Manager. To do this, on the Home tab, in the Styles section, click Conditional Formatting, and then click Manage Rules. In the Conditional Formatting Rules Manager dialog box, you can use the Move Up and Move Down arrows to reorder rules, which determines what formatting appears in front. You can also select the Stop If True option to stop executing further rules in cells for which the selected condition is true.