Add More Rules

3. 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. So...what do you see?

Form Tools ->Datasheet->Formatting-> Conditional Formatting

Exam 77-885: Microsoft Access 2010

3. Building Forms

3.4. Apply Form Format options: Use Conditional Formatting