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

Data Validation in Microsoft Excel allows users to control the type of data entered into the worksheet. It picks from a list of rules to limit the type of data that can be entered into a cell.

How to Make Colors Change With Validation in Excel. Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border.

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' ...