Sometimes you need to put emphasis of certain cells of your reports or forms. There is one facility to accomodate this in Access. It is called Conditional Formatting.

You can access this from Layout View of forms or report. In Font Ribbon group you can access the button called Conditonal. This will open a dialog form where you can specify the conditons for the dynamic format, and the kind of formatting you want to apply.

Source article: