Select the cell or a range. Click the Home tab. Click the Conditional Formatting button. Then click Manage Rules.
|
|
![Click the Home tab. Click the Conditional Formatting button. Then click Manage Rules.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Edit_Conditional_Formatting_Rule_Precedence___Click_Home_Tab_Click_Conditional_Fo.PNG) |
Click the Show formatting rulers for list arrow. Choose an option to show the rules.
|
|
![Click the Show formatting rulers for list arrow. Choose an option to show the rules.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Edit_Conditional_Formatting_Rule_Precedence___Click_Show_Formatting_Rulers_For_Li.PNG) |
To change the rule in precedence, click Move Up or Move Down.
|
|
![To change the rule in precedence, click Move Up or Move Down.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Edit_Conditional_Formatting_Rule_Precedence___To_Change_Rule_In_Precedence_Click_.PNG) |
To stop rule evaluation for a specific rule, select the Stop If True.
|
|
![To stop rule evaluation for a specific rule, select the Stop If True.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Edit_Conditional_Formatting_Rule_Precedence___To_Stop_Rule_Evaluation_For_Specifi.PNG) |
To delete a rule, click Delete Rule.
|
|
![To delete a rule, click Delete Rule.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Edit_Conditional_Formatting_Rule_Precedence___To_Delete_Rule_Click_Delete_Rule.PNG) |
To edit a rule, click Edit Rule. Click OK.
|
|
![To edit a rule, click Edit Rule. Click OK.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Edit_Conditional_Formatting_Rule_Precedence___To_Edit_Rule_Click_Edit_Rule_Click_.PNG) |
|
![Check the result.](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Edit_Conditional_Formatting_Rule_Precedence___Check_Result.PNG) |
No comments:
Post a Comment