Conditional Formatting

As in”‘Excel”, in “Access” also, we have the “Conditional Formatting”.
But for those of you who have never heard of this, let me first explain what “Conditional Formatting” means.
By using a conditional format, we can format data, based on the value of a field.
For example: if a student has a score of less than 50, then display this value in red.

First, open your report in “Layout View” or “Design View”.
Select the field you want to apply the “Conditional formatting” (1) for. In this case, it is “Score”.
Click the “Font” button in the “Ribbon”, under the “Format” tab.
Select the “Conditional Formatting” in the drop-down menu.

This opens the “Conditional Formatting” dialog.
In the upper part of the dialog, you can enter a format to be used when no condition is met. (Section “Default Formatting”)
Below, in the “Condition 1” section, the first box “Field Value is” is selected.
In the second box, choose “less than”.
And in the third box you enter a value, in this case 50.
Click the OK button when you’re done.

You can enter up to 3 conditions.
Just click the “Add>>” button in the dialog and enter the following condition, for example between 50 and 80, the text to be in blue.
And condition 3, greater than 80, the text to be in green.

You have the options to set the background colors, text colors, text underline, italics or in bold display.
But I think you already know that.
Click the OK button when you’re done.
Result:

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats