Edit the Formatting Rule

Each value in the Rating data will be assigned a different color.

 

3. Try it: Edit the Formatting Rule

Field Value is: equal to

Enter the Rating: G

Format the color: green

 

Keep going...

 

Memo to Self: Be consistent. We used Conditional Formatting in the Movie Search Subform. It is OK to match the colors in the Report.

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

Exam 77-885: Microsoft Access 2010

5. Designing Reports

5.4. Apply Report Format options: Use Conditional Formatting