Microsoft Office Tutorials and References
In Depth Information
Adding conditional formatting
Adding conditional formatting
Conditional formatting applies to both forms and reports and
allows you to create colorful presentations in which you format
a cell in a record to highlight its value as compared to other
fields or values. A simple example would be to display all cell
values of less than zero on a red background.
In addition to changing the formatting colors of a cell, you
can display a data bar that shows the value compared to the
field’s range of values in the report or against a specific range
of values, providing a quick visual indication of how the data
compares against other values.
1
3
2
Add conditional formatting
1 Select a field that contains numerical values.
2 Click Conditional Formatting in the Control Formatting group on
the Format tab.
3 Click New Rule.
4 Change the rule type to Compare To Other Records.
5 In the Type field, change Lowest to Number and Highest to
Number. (The default compares against the lowest and highest
values in the report.)
6 Type Values for the shortest and longest bars. In our example, we
entered 100 to 1000.
7 Click OK. (Also click OK to close the Conditional Formatting Rules
Manager dialog box, and select Layout View from the View
dropdown menu on the Design tab.)
4
6
5
In layout view, click Conditional Formatting to make further
changes to the presentation.
8
8
7
Search JabSto ::




Custom Search