Excel Dictionary on MSN

How to create color-coded dropdowns in Excel

In this video, you'll learn how to create dynamic, color-coded dropdown menus in Excel that automatically highlight cells a ...
Hosted on MSN

Excel's data validation is far more powerful than just dropdowns — here's what it can actually enforce

Most people set up a dropdown list to make spreadsheets smarter with Excel's data validation. However, the Custom option in the Data Validation dialog accepts any formula that returns TRUE or FALSE, ...