Microsoft Office Tutorials and References
In Depth Information
Making Reports Look Pretty
3. Click the Format tab.
4. Click the Conditional Formatting icon in the Control Formatting group.
A Conditional Formatting Rules Manager dialog box appears, as shown
in Figure 18-10.
5. Click the New Rule button.
A New Formatting Rule dialog box appears, as shown in Figure 18-11.
You can click the Edit Rule or Delete Rule button here to edit or delete a
rule that you’ve created.
box lets you
6. Select a rule type:
• Check values in the current record or use an expression (you can
create a rule that only considers the value of a single field).
• Compare to other records (you can create a rule that examines the
value of the same field stored in other records).