Adding conditional formatting and data bars to a report


show more Adding conditional formatting and data bars to a report provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Adding conditional formatting and data bars to a report

When reading a report, it's helpful to instantly be able to identify any unusual numbers or data. Conditional Formatting allows you to change the appearance of your results according to the criteria you specify. One method, Data Bars, even gives you a graphical comparison of your values. Scroll down in the Navigation pane, right-click on Products Report and choose Layout View. As we look at our products, we'd like to see our most profitable product lines. Let's turn any profits bold and green if they're over $7.

Click on one of the profits, and go up to the Report Layout tools and the Format Ribbon, and click on Conditional Formatting. You have the ability to set multiple rules for multiple fields without ever leaving this window. Let's leave this on what we clicked, and click on New Rule. Leave the default on top, check the values in the current record. You can choose between the Field Value or an Expression, which is a calculation. We'll leave that on Field Value. C...

Adding conditional formatting and data bars to a report
Video duration: 2m 38s 3h 30m Beginner

Viewers:

Adding conditional formatting and data bars to a report provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...