How to revise a conditional formatting rule

Abstract

Once aconditional formatting rulehas been created, it can be easily revised.

Let’s take a look.

Once a conditional formatting rule is defined, it can be revised or deleted.

To see and edit a conditional formatting rule, select Manage Rules from the Conditional Formatting menu.

By default the Manage Rules dialog box is set to the Current Selection.

If not, switch the dropdown menu to This Worksheet.

To edit the rule, select it in the list and go for the “Edit Rule” button.

you could then adjust both the condition and the formatting applied.

Let’s adjust the threshold for our rule to 95.

Click OK to return to the Rules Manager, and OK again to confirm the change.

Now let’s edit the formatting.

Again, we select Manage Rules from the Conditional Formatting menu.

Then choose the rule and click Edit Rule.

This time, we nudge the Format button.

When you click Format, you’ll see a stripped down version of the Format Cells dialog box.

Let’s change the fill to a darker green, and set the font color to white.

Click OK again to confirm the change.

Finally, let’s look at how to adjust which cells the conditional formatting rule applies to.

The easiest way to update this reference is to tap the button at the right.

Excel will collapse the window, and wait for you to make a selection in the worksheet.

Just choose the cells you’d like to format and press enter to confirm the selection.

Then press OK to confirm the change and return to the worksheet.