Microsoft Office Tutorials and References
In Depth Information
and to spot important trends in your data. For
example, if sales for any salesperson fall beneath
their quota, you could have Excel automatically
format it in red or with shading or borders. Follow
these simple steps:
type a value here, such as 500, or you can
reference a cell address such as F13.
5. Click the drop-down arrow next to the
format options so you can specify the format
options to employ if the condition you
specified is true. Live Preview shows you what
your data will look like.
Select the cells to which you want to apply
Click the Custom Format option where you
can create your own format, selecting from
font styles and color, numeric and other
formats, borders, patterns, or background color.
Reasons for using conditional formatting
might include locating dates that meet a
certain condition (such as falling on a Saturday
or Sunday), specifying highest or lowest
values in a range, or indicating values that fall
under or over a specified amount.
6. Click OK. (In Figure 10-31, you see formatting
options applied to seven cells that meet the
specified criteria of being greater than the
2. Choose Home>Styles>Conditional
Formatting>Highlight Cell Rules.
3. Select the criteria you want to use. Criteria
options include Greater Than, Less Than,
Between, Equal To, Text That Contains, A
Date Occurring, and Duplicate Values. A
dialog box opens where you can specify the
value. In Figure 10-30, in order to see which
grade averages were over 75%, you use the
Greater Than criteria.
Specifying conditions for formatting.
4. Enter the values you want to reference in the
text box. The number of boxes depends on
the criteria you selected in Step 3. You can
Cells with conditional formatting applied.