From the course: Excel: Data Validation in Depth

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Solution: Apply data validation and messages

Solution: Apply data validation and messages - Microsoft Excel Tutorial

From the course: Excel: Data Validation in Depth

Start my 1-month free trial Buy for my team

Solution: Apply data validation and messages

“

(upbeat music) - [Instructor] Okay, welcome back. Let's take a look at how I accomplished this challenge. Okay, our first prompt was to make sure that number and party never exceeds 15. So I'll go ahead and highlight number and party. I'll go to Data, I'll go to Data Validation. I'll set it to a whole number, and I can choose either less than or equal to 15 or between one and 15. Either one would work. I'll do less than or equal to 15. The other option was to create an error alert and I'll do invalid party count. Parties are limited to 15 people or less. Please adjust and try again. Perfect. Now, I could go ahead and supply an input message here but it would actually put the input message on every single cell. I'll go ahead and do that, and then come back and remove it. All right. Please keep party to 15 or less. Parties cannot exceed 15 people. All right, so I'll go ahead and click OK here. Now remember, it's…

Contents