Microsoft Office Tutorials and References
In Depth Information
Create a Custom Conditional Formatting Rule
Chapter 5: Analyzing Excel Data
The New Formatting Rule
dialog box appears.
5 Click the type of rule you
want to create.
6 Edit the rule’s style and
The controls you see
depend on the rule type
With Icon Sets, click
Reverse Icon Order if you
want to reverse the
normal icon assignments,
as shown here.
7 Click OK.
Excel applies the
conditional formatting to
each cell in the range.
If you need to make changes
to your custom conditional
formatting rule, follow steps 1
to 3 to select the range and
display the Conditional
Formatting drop-down menu,
and then click Manage Rules.
Excel displays the Conditional
Formatting Rules Manager
dialog box. Click the rule you
want to modify and then click
If you want to delete a custom rule for a worksheet,
click the Home tab, click the Conditional Formatting
drop-down arrow, and then click Manage Rules to
open the Conditional Formatting Rules Manager dialog
box. In the Show Formatting Rules For list, click This
Worksheet. Click the rule you want to remove and
then click Delete Rule. If you have multiple custom
rules defined for a worksheet and you no longer
require them, you can remove all of them. Click the
Home tab, click the Conditional Formatting drop-down
arrow, click Clear Rules, and then click Clear Rules
from Entire Sheet.