Formatting conditionally


show more Formatting conditionally provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Forms and Reports in Depth show less
please wait ...

Formatting conditionally

When skimming a long report, it could be pretty easy to skip right over some very significant numbers. By utilizing the Conditional Formatting rules within your reports, you can make sure that the values that were in the second look get noticed. We will continue building on a Lifetime Sales report that we made in the last movie. I'll double-click on it to open it to review where we are at. Now let's go ahead and switch into Design View. I will change my view here, switch to Design View. We want to call out some data from our report. Let's say that we wanted to highlight all of the values of Lifetime Sales that were less than $20. I will click on Lifetime Sales here, go up to the Format Tab, and click on Conditional Formatting.

This will start up the Conditional Formatting Rules Manager where we can apply rules for formatting our data. I am going to click on New Rule, and we can tell Access that I want to format all the cells where the field value is less than, and I will type-in ...

Formatting conditionally
Video duration: 6m 59s 3h 7m Intermediate

Viewers:

Formatting conditionally provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Forms and Reports in Depth

Subject:
Business
Software:
Access
Author:
please wait ...