Microsoft Office Tutorials and References
In Depth Information
Highlighting Trends and Variations in Data
To get started, select a range of data and then click Conditional Formatting in the Styles
group on the Home tab. That displays the Conditional Formatting menu:
Each of the five main choices on this menu provides access to a range of preset rules. The
More Rules option at the bottom of each of the submenus allows you to create custom
choices that vary from the preset configurations. The following list describes what you’ll
find in each of the five main choices:
Highlight Cells Rules Each of the seven preset options opens a dialog box that lets
you construct a formula using a comparison operator (greater than, less than, equal
to, and so on) along with a value or cell reference to compare with each cell’s
contents. Excel ills in values using its internal algorithms; you can change those values or
point to a cell reference. The box on the right allows you to choose the formatting to
be applied to cells matching your specified conditions.
Top/Bottom Rules The input dialog box that opens when you select any of the
choices on this menu also allows you to create a rule on the fly. Don’t be misled by
Search JabSto ::




Custom Search