Displaying thresholds on a report

Individual cell data can be automatically formatted differently than the data in the rest of the report. Data that is formatted differently calls attention to itself, and makes that data easier to locate for analysis.

To see a report displaying various types of thresholds, such as symbols, highlighted values, and so on, see the Formatting a Report chapter in the Basic Reporting Guide.

Conditional formatting is formatting that is applied to values when certain conditions are met.  For example, it is possible to have all profit margins below a certain percentage appear in red, while all other profit margins are displayed in black. The data that meets the condition is considered to be data that has passed the threshold of the condition; once data passes the threshold, the formatting is applied. So thresholds are cells of data that are formatted differently from the rest of the data on a report; the formatting is applied dynamically, whenever the report is re-executed.

Thresholds highlight particular data in a report by displaying special cell formats, symbols, images, or replacement text.

To display the thresholds on your report

  1. Run a report.

  2. From the Tools menu, select Report Options. The Report Options dialog box opens. On the Grid tab, select the Show thresholds check box.

  3. Click OK at the bottom of the dialog box. Any thresholds in the report are displayed.

Related topic