Defining alert exceptions

To define alert exceptions:

  1. Highlight the data on which to create the alert exception. You can select a cell, range of cells, or an entire row or column.
  2. In the Exceptions group, select Alert > Add.
  3. In the Name box, specify a name for the exception.
  4. For Data Range, specify a minimum amount (Bottom column) and maximum amount (Top column) for the range. An alert is displayed if a value is greater than the minimum amount and less than or equal to the maximum amount.
  5. Click OK.