Microsoft Office Tutorials and References
In Depth Information
Applying Conditional Formatting
The Salary column is selected prior
to setting conditional formatting
The first method for applying conditional
formatting you’re going to look at is the Highlight
Cells Rules command, following these steps:
1. With your worksheet (or a desired portion
thereof) selected, click the Conditional
Formatting button on the Home tab’s Styles
When selecting the portions of your
worksheet to which conditional
formatting should apply, select only the rows
and/or columns that contain numbers
or other values (including text) that you
want to format. Don’t select the entire
worksheet unless you want all the cells
to be checked for the conditions you set
and the desired values are found
Select the section of your worksheet where the
conditions can be found and then begin
setting up conditional formatting.
Two questions must be answered—greater
than what, and when that value is found,
how should it be formatted?
2. Choose Highlight Cells Rules, and view the
submenu, shown in Figure 5-34.
3. Select the conditions Excel should look for
within the selected cells, from Greater Than
to Duplicate Values, for a total of seven
conditions to choose from. Each of the options
results in a dialog box, and Figure 5-35
shows the Greater Than dialog box, which
you’ll use for this example.
If you prefer, you can move or shrink the
dialog box and click on a cell to establish
the value in the Greater Than (or any other
dialog box opened from the Conditional
Formatting menu) field. In Figure 5-35,
the number was typed manually.