Microsoft Office Tutorials and References
In Depth Information
Create a Custom Conditional Formatting Rule
Create a Custom Conditional
You can tailor your format-based data analysis
by creating a custom conditional formatting
rule that suits how you want to analyze and
present the data.
The predefined conditional formatting rules in
Excel — highlight cells rules, top/bottom
rules, data bars, color scales, and icon sets —
give you an easy way to analyze worksheet
values through data visualization.
However, you might find that these predefined
rules do not suit particular types of data or
data analysis. For example, the icon sets assume
that higher values are more positive than lower
values, but that is not always true; in a database
of product defects, lower values are better than
higher ones. Similarly, data bars are based on
the relative numeric values in a range, but you
might prefer to base them on the relative
percentages or on percentile rankings.
To get the type of data analysis you prefer, and
to create your own formats, you can create a
custom conditional formatting rule and apply it
to your range.
1 Select the range you
want to work with.
2 Click the Home tab.
3 Click Conditional
4 Click New Rule.