22.3 Add Conditional Formatting to the Report

The steps in this section will show you how to add conditional formatting so that salaries greater than or equal to $10,000 will be highlighted in bold, red text, and salaries between $4,999 and $10,000 will be highlighted in bold text.

Since the data retrieved cannot be both greater than or equal to $10,000 and between $4,999 and $10,000, you will need to create two separate format exceptions. In this section, you will see how to create each distinct format exception.

To add conditional formatting:

In the Paper Design view, right-click the Salary column of data (not the Salary column heading), then choose Conditional Formatting.

In the Conditional Formatting dialog box, click New to create a new Format Exception.

In the Format Exception dialog box, make sure SALARY is selected.

Next to SALARY, choose Greater Than or Equal from the list.

In the next box, type 10000.

Under Format, click the icon next to Text Color to display the color palette.

Note:

You can choose as many options as you want in the Format Exception dialog box, such as text color, style, and font.

Click Red.

Click Font, then choose Bold.

Click OK to accept the new font style.

You should now see the following options selected in the Format Exception dialog box: