From the course: Excel Weekly Challenge

Unlock this course with a free trial

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

Create a custom message in data validation

Create a custom message in data validation - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Create a custom message in data validation

“

- You and I have a delivery service and people won't listen. We keep telling 'em, but people keep messing this up. So we need to put in some data validation to the distance column so that if anybody tries to assign a distance more than 50 miles, they will get a pop-up alert saying contact Erica. So that's one thing we have to do. Then, test it. Always test once you've applied something new and then notice that there are drop-down lists here and I'm going to apply this to Lars. We need to add JC to the list of options of drivers and you got to find where that list is, all right. So pause the video. Work that out. Come back and I'll show you one way of doing this. Okay, let's do this. I'm going to first add JC as a driver. Let's see where this data validation is living. I'm going to go to the Data tab. Over here, Data Validation. All right here it says equals drivers, so that tells me that there is a driver's named…

Contents