Microsoft Office Tutorials and References
In Depth Information
Conditionally
FORMAT YOUR WORKSHEET
If you want to monitor your data by highlighting
certain conditions, Excel’s conditional formatting
feature can aid you. For example, if your company
offers a bonus whenever sales exceed 150,000
dollars, you can have Excel highlight cells containing
sales figures whenever the value is more than
150,000 dollars. You can also have Excel highlight
a cell when the entry is less than, between, or equal
to a specified value. Use Excel’s conditional
formatting feature to monitor text, dates, duplicate
values, the top N, the top N percent, the bottom N,
the bottom N percent, above average values, or
below average values.
Changes affect conditionally-formatted data. If, after
a change, a cell no longer meets the condition, Excel
removes the highlighting. If, after a change, a cell
meets the condition, Excel adds highlighting. You
determine exactly what the condition is and what
should happen if a cell meets the condition. Excel
provides you with a list of formats from which to
choose, and you can also create a custom format.
2
C ONDITIONAL F ORMAT
1
3
4
5
Click and drag to select the data
you want to monitor.
2
Click the Home tab.
3
Click Conditional Formatting.
A menu appears.
4
Click to select a menu option.
A submenu appears.
1
5
Click to select a menu option.
l A dialog box appears.
Note: This example uses
Greater Than.
6
Type your criteria.
7
Click here and select the
formatting you want to apply.
You can choose to create a
custom format.
8
Click OK.
l Excel highlights all of the data
that meets your criteria.
6
7
8
72
 
Search JabSto ::




Custom Search