Parameter fields can be used to create
conditional formatting formulas. You can specify new values for these formulas
whenever you refresh the report data. A conditional formatting formula could be
used for color-flagging data that meets certain conditions. For example:
Sales representatives who sell more
than 10% over quota.
Customers who have not ordered in the
last quarter.
Inventory items that have not had any
movement in the last month.
If the conditions under which you flag
these items never change, you do not need to use parameter fields. You can just
use formulas. However, to change the conditions, you need to use parameter
fields in formulas and conditional formatting formulas.
For example, if you want the names of all
the customers whose last year's sales were over a certain value to display in
red, you might follow the steps in this procedure.