From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Use custom formulas in data validation to keep out bad data

Use custom formulas in data validation to keep out bad data - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Use custom formulas in data validation to keep out bad data

- [Instructor] Excel's Data Validation feature found on the Data tab, is different than a lot of other data management tools because instead of dealing with data that's already there, it's designed to control data before it gets into a worksheet. Let's say that in this worksheet, we want these shipping dates to be entered here, and the shipping date has to be more than three days after the order date. When using data validation, it's not uncommon to select an entire column. Often you are working with lists. The lists might grow, so let's apply the rule to all of the cells in column C, so on the Data tab, Data Validation, first thought in the example here is, under the category allow, what would we allow in column C. Let's go to date. Now there are some great choices here for restricting the dates between two different dates, later than a certain date, before a certain date. But if we're dealing with data in column B, none of these options actually quite fits. And so the other option…

Contents