Exam 77-424: Microsoft Access 2013
5.0 Create Reports
5.2 Set Report Controls: Use Conditional Formatting

Add More Rules

4. Try it: Add More Rules

Add a Rule for the PG Rating

Click on New Rule.
Field Value is: equal to
Enter the Rating: PG
Format the color: orange

 

Add a Rule for the R Rating

Click on New Rule.

Field Value is: equal to

Enter the Rating: R

Format the color: red

 

Show formatting rule for Rating:

There should be three rules.

 

Click OK. Keeeeeep going.

Report Design Tools->Format->Control Formatting->Conditional Formatting

graphic1
graphic2