Microsoft Office Tutorials and References
In Depth Information
Formatting a cell based on conditions
Formatting a cell based on conditions
Another way you can make your data easier to interpret is to
change the appearance of your data based on the value in a
cell. This kind of formatting is called conditional formatting
because the data must meet certain conditions to have a format
applied to it. For example, if you use a worksheet to track your
customers’ credit lines, you could have a customer’s
outstanding balance appear in red if they are within 10 percent of their
credit limit.
2
Change the format of a cell based on its value
1 Select the cells that you want to change.
2 Click the Home tab.
3 In the Styles group on the ribbon, click Conditional Formatting.
4 Click New Rule.
5 Click Format Only Cells That Contain.
6 Click the Comparison Phrase down arrow.
7 Click the comparison phrase that you want.
8 Type the constant values or formulas that you want evaluated.
9 Click Format.
10 Specify the formatting that you want, and click OK.
11 Click OK.
3
4
1
8
5
10
CAUTIoN The layout of the Edit The Rule Description pane
changes to reflect the rule type that you choose. Don’t be
surprised if you see a different number of fields than are shown here.
7
6
9
11
Search JabSto ::




Custom Search