Excel+2007+Conditional+Formatting

You create, edit, delete, and view all conditional formatting rules in the workbook by using the ****Conditional Formatting Rules Manager**** dialog box. (On the ****Home**** tab, in the****Styles**** group, click the arrow next to ****Conditional Formatting****, and then click ****Manage Rules****.) When two or more conditional formatting rules apply to a range of cells, these rules are evaluated in order of precedence by how they are listed in this dialog box.