Validating data in excel dating parties dallas
Learn how you can overcome this issue in the video below.
By using validation rules, we can limit the mistake a user may make.
In this example, cell A2 is the upper left cell of the selected range of cells.
You can create Data Validation rules that are based on the value from another cell by writing a custom formula.
In the Source box you can type =city to reference the named range.
For the dependent list in cell G2, the selection in cell F2 needs to be converted into a reference to the named ranges.