Editing conditional formatting rules

After you create a conditional formatting rule, you might need to change it to…reflect new operating additions or goals of your company.…For example, you might revise your sales targets to reflect an economic downturn…or you could decide to pay a bonus to the top 15% of your sales representatives…instead of your top 10 because you had a great year.…To edit a conditional format, you click any cell that contains the format as…I've done here, and then on the Home tab of the Ribbon, click the Conditional…Formatting button and then click Manage Rules.…

When you do, the Conditional Formatting Rules Manager dialog box appears and…then you can click any rule that you want to edit.…In this case there's only oneso I will click it.…So it's highlighted in blue and then to open the editing box I'll click the Edit Rule button.…You can use the controls in the Edit Formatting Rule dialog box to change every…aspect of your conditional format,…including the type of rule, the cells to which it's applied, and the rule's conditions.…