How to Remove the Background from a Graphic Image in Office 2013
How to Create and Enter Data in an Access 2013 Form
How to Record an Audio Note in OneNote 2013

How to Create Conditional Formatting in Access 2013

Formatting data based on certain criteria is known as conditional formatting. A report in Access 2013 can display data, but sometimes you may want help in identifying certain types of data. While you can manually examine a report and highlight information yourself, it’s faster and more accurate to let Access do it instead.

To use conditional formatting, you need to define the field to format, define a rule to trigger the formatting, and then the type of formatting you want to apply, such as highlighting the field in red or yellow.

To apply conditional formatting to data in a report, display your report in Design view and follow these steps:


Select the field to which you want apply conditional formatting.

You can apply conditional formatting to a numeric or text field.


Click the Format tab and click the Conditional Formatting icon in the Control Formatting group.

A Conditional Formatting Rules Manager dialog box appears.


Click the New Rule button.

A New Formatting Rule dialog box appears.

You can click the Edit Rule or Delete Rule button here to edit or delete a rule that you’ve created.


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).


Define your rule under the Edit the Rule Description category.

Depending on the option you chose in the preceding step, the Edit the Rule Description category may display different options.


Choose the type of formatting to display if the data in a field matches the rule that you defined.

Click OK. The Conditional Formatting Rules Manager dialog box appears again, displaying your newly created rule.


Click OK.

Access now displays your formatting changes in the field if it matches your defined rule.


Click the Print Preview button.

Access shows how your report will appear with the conditional formatting applied.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
How to Compare Documents in Word 2013
How to Create Rules for Arriving Messages in Outlook 2013
How to Establish Data-Validation Rules in Excel 2013
How to Run a Program through a Hyperlink in PowerPoint 2013
How to Share Your Office 2013 Files and Folders