Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

Use a Validation list to chose the correct item for your data in Excel. You have a data file that needs to be updated by either one or several different people. It would make their task and your ...

I've got an Excel 97 worksheet in which I need to validate some cells. No problem, I'll just use Data->Validate, right? Wrong. The built in validation works well enough as long as the user doesn't ...

I have a tracker. People putting lower case letters in codes is not cool, so I want to make it so my spreadsheet either rejects them, or better yet, corrects them. I've found the 'data validation' ...