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.
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.
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.
Search JabSto ::

Custom Search