From the course: Access 2016: Forms and Reports

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Apply conditional formatting rules

Apply conditional formatting rules

From the course: Access 2016: Forms and Reports

Start my 1-month free trial

Apply conditional formatting rules

- [Voiceover] When skimming a long report, it can 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 values that warrant a second look get noticed. We'll continue building on the Customer Lifetime Sales report that we started in a previous movie. Let's go ahead and double-click on it to open it up. Now in this case, I want to scroll through here and highlight all of my customers that have spent less than $100 with the company. I can do that with conditional formatting rules. And to get to those, we'll go into the Design View. I'll select the field that has the value I want to compare and come up to the Format tab and press Conditional Formatting. Here we'll add a new rule. We can come down here and it says, "Field value is," and I'll change between to less than. Then I'll type in the number 100. If this statement is true, the field value, in this case, the lifetime sales value, is…

Contents