Excel's Built-in Features

MS Excel - Excel's Built-in Features

Validate Data Based on a List on Another Worksheet Control Conditional Formatting with Checkboxes Identify Formulas with Conditional Formatting Count or Sum Cells That Meet Conditional Formatting Criteria Highlight Every Other Row or Column Create 3D Effects in Tables or Cells Turn Conditional Formatting and Data Validation On and Off with a Checkbox Support Multiple Lists in a ComboBox Create Validation Lists That Change Based on a Selection from Another List Force Data Validation to Reference a List on Another Worksheet Use Replace... to Remove Unwanted Characters Convert Text Numbers to Real Numbers Customize Cell Comments Sort by More Than Three Columns Random Sorting Manipulate Data with the Advanced Filter Create Custom Number Formats Add More Levels of Undo to Excel for Windows Create Custom Lists Boldface Excel Subtotals Convert Excel Formulas and Functions to Values Automatically Add Data to a Validation List Excel's Date and Time Features

Data validation makes it easy to specify rules your data must follow. Unfortunately, Excel insists that lists used in data validation must appear on the same worksheet as the data being validated. Fortunately, there are ways to evade this requirement.
In this tutorial, we provide two methods you can use to validate data based on a list on another worksheet. The first method takes advantage of Excel's named ranges, and the second uses a function call.

[Next]