Page 245 - Excel 2013 All-in-One For Dummies

Marking Invalid Data 227
the data (by circling their cells) that are outside of expected or allowable parameters.
To use the Data Validation feature in this way, you follow this general procedure:
✦ Select the cell range(s) in the worksheet that need to be validated and marked.
✦ Open the Data Validation dialog box by clicking the Data Validation button on the Data tab of the Ribbon or by pressing Alt+AVV, and then use its options to set up the validation criteria that determine which values in the selected cell range are out of bounds. (See Book II, Chapter 1 for details.)
✦ Choose the Circle Invalid Data option from the Data Validation button’s drop-down menu on the Data tab of the Ribbon.
Figure 3-19 shows an example of how you might use Data Validation to mark entries that are below a certain threshold. In this case, I set it up for Excel to mark all subtotal monthly sales cells entries in the range D4:D15 in the 2013 Sales worksheet that are above $50,000 by drawing a red circle around their cells.
Figure 3-19:
Using Data Validation to mark unexpected entries (monthly sales above $50K) in a data table.
Book II Chapter 3
Editing and Proofing Worksheets