Microsoft Office Tutorials and References
In Depth Information
Apply Conditional Formatting
Apply Conditional
Formatting
You can use conditional formatting to apply
certain formatting when the value of a cell meets
the required condition. For example, if your
worksheet tracks weekly sales, you might set up
conditional formatting to alert you if a sales figure
falls below what is required for you to break even.
You can also use color scales and data bars to help
you distinguish the degree to which various cells
meet your conditional rules.
Apply Conditional Formatting
Apply a Conditional Rule
1 Select the cell or range to which
you want to apply conditional
formatting.
2 Click the Home tab on the Ribbon.
3 Click the Conditional
Formatting button.
4 Click Highlight Cells Rules .
5 Click the type of rule that you
want to create.
2
3
4
5
1
A rule dialog box appears.
6 Specify the values that you want
to assign for the condition.
7 Click OK.
6
7
160
 
 
 
Search JabSto ::




Custom Search