Multiple Validation Rules Excel How To Have Multiple

One way is to make it harder for them to make mistakes when filling out the form.

For example, by using data validation in Excel 2011 for Mac, you can make sure that someone enters a particular kind of data (such as a date, number, or text) into an input field.

Or, on the Ribbons Data tab, go to the Tools group and click Validate.

Pressing the Tab key wont advance to the next field until a satisfactory entry is made.

After all, you dont want to hurt feelings or ruffle feathers.

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

Retrieve License Lost license Report a Bug Bug report Forum Post in forum Contact Us Talk to us via Email.

Select the cells that you want to apply multiple data validation, then click Data Data Validation Data Validation, see screenshot: 2.

In the Data Validation dialog box, under the Settings tab, do the following operations: (1.) Choose Custom from the Allow drop down list; (2.) Enter this formula: OR(A2 into the Formula text box.

Note: In the above formula, A2 is the cell which you want to apply the data validation, C2 and D2:D7 are the criteria you need to apply the data validation based on.

Then click OK, from now on, only the values which matching the criteria can be entered into the cells, if not, a warning prompt box will pop out to remind you, see screenshot: Apply multiple data validation in one cell (Example 2) In this example, I will only allow the text Kutools for Excel or the date between 1212017 and 12312017 can be entered into the specific cells as below screenshot shown.

Go to the Data Validation dialog box, and in the dialog box, please do the following operations: (1.) Click Settings tab; (2.) Select Custom option from the Allow drop down list; (3.) Type this formula: OR(A2C2,AND(A2DATE(2017,12,1), A2 into the Formula text box.

Note: In the above formula, A2 is the cell which you want to apply the data validation, and you can change the criteria in the formula to your own.

Then click OK button, and now, only the text values which matching the criteria you specified are allowed to be entered, see screenshot: Note: May be there are other different data validation criteria needed to be applied, you can create your own formulas for different criteria as you want.

The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80 Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails.

Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range.

Merge CellsRowsColumns without losing Data; Split Cells Content; Combine Duplicate RowsColumns.

Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select.

Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more.

Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments.

Super Filter (save and apply filter schemes to other sheets); Advanced Sort by monthweekday, frequency and more; Special Filter by bold, italic.

Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF.

Open and create multiple documents in new tabs of the same window, rather than in new windows.

Increases your productivity by 50, and reduces hundreds of mouse clicks for you every day Read More.

Free Download. Purchase.

Comments Login Sort by Newest Best Popular Newest Oldest Say something here.

Iras 9 months ago Is it possible to apply data validation on the calcuated column attribute Reply To post as a guest, your comment is unpublished.

If they select all three, it shows in cell as: apple, grade, banana.

Multiple Validation Rules Excel How To Have Multiple

David 1 years ago Any idea how to have multiple data validation and a drop down.

Otherwise if the dropdown is selected the error message appears.

Sitemap Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States andor other countries.

Products.

Multiple Validation Rules Excel For Mac