Conditional Formatting

Dear Kerstin

Thank you for attending Access 2007 Introduction course!! I hope you enjoyed the course and benefited from it.

This is an interesting question and you have to follow these steps to achieve the results:


1. Open the form or the report that you wish to apply the conditional formatting to

2. Choose the Layout View of the Form or report

3. Choose the all the fields that you wish to change the formatting of. You might have to use the CTRL or SHIFT button while selecting the fields. (Please ensure that you select the fields where the actual data is and NOT the headings)

4. Once all the fields have been selected then choose Conditional Formatting button on the ribbon

5. In the condition 1 choose Expression is from the drop down arrow

6. In the second box type the name of the field in square brackets and the condition that it should meet e.g.
[qty_sold] >1000

7. Apply the formatting of your choice as to how you would like the fields to look like if the field meets the set criteria!

8. Press OK.

When you go to the Form view you'll be able to see the entire records will be formatted if they meet the condition set on the field in the conditional formatting dialog box.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007