From the course: Microsoft Access Essential Training (Office 2024/LTSC)

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Apply conditional formatting rules

Apply conditional formatting rules

From the course: Microsoft Access Essential Training (Office 2024/LTSC)

Start my 1-month free trial Buy for my team

Apply conditional formatting rules

“

- [Instructor] Conditional formatting rules can be applied to your reports, which will call attention to specific values that you'd like to highlight. Let's create a new report to analyze the Two Trees monthly revenue summary. Now we have a query that we started earlier in the course that we can use. This one counts up the number of orders for each month. I do need to add an additional calculation here to find the revenue for each month. So I'm going to take this into design view. Then I'll turn on the add tables panel, switch over to the tables group and add in the products table. That'll give me the price of each product, and we can get the revenue by calculating the price times the quantity ordered for each month each. I'll do that here in this next column, the fourth column over here on the right, I'll just right click and go into the zoom box so I can type in the formula. We'll start with the name of the column revenue, type in a colon, and the formula is simply price times…

Contents