'Data validation' category
Subcategories
How to automatically add new items to a drop down list
A drop-down list in Excel prevents a user from entering an invalid value in a cell. Entering a value that […]
A drop-down list in Excel prevents a user from entering an invalid value in a cell. Entering a value that […]
Prevent duplicate records in a worksheet
This article demonstrates how to set up Data Validation in order to control what the Excel user is allowed to […]
This article demonstrates how to set up Data Validation in order to control what the Excel user is allowed to […]
Compare data in an Excel chart using drop down lists
I will in this article demonstrate how to set up two drop down lists linked to an Excel chart, the […]
I will in this article demonstrate how to set up two drop down lists linked to an Excel chart, the […]
Run a Macro from a Drop Down list [VBA]
This article demonstrates how to run a VBA macro using a Drop Down list. The Drop Down list contains two […]
This article demonstrates how to run a VBA macro using a Drop Down list. The Drop Down list contains two […]
Advanced Techniques for Conditional Formatting
Table of contents How to change cell formatting using a Drop Down list Highlight cells based on coordinates Highlight every […]
Table of contents How to change cell formatting using a Drop Down list Highlight cells based on coordinates Highlight every […]
How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas – use named ranges
This article demonstrates different ways to reference an Excel defined Table in a drop-down list and Conditional Formatting. There are […]
This article demonstrates different ways to reference an Excel defined Table in a drop-down list and Conditional Formatting. There are […]
Populate drop down list with filtered Excel Table values
This article demonstrates how to populate a drop down list with filtered values from an Excel defined Table. The animated […]
This article demonstrates how to populate a drop down list with filtered values from an Excel defined Table. The animated […]
Use a drop down list to display data in worksheet header [VBA]
Aynsley Wall asks: I have a spreadsheet that I use for 3 different companies. What I would really like to […]
Aynsley Wall asks: I have a spreadsheet that I use for 3 different companies. What I would really like to […]
Use a drop down list to search and return multiple values
I will in this article demonstrate how to use a value from a drop-down list and use it to do […]
I will in this article demonstrate how to use a value from a drop-down list and use it to do […]
Create dependent drop down lists containing unique distinct values
Table of Contents Create dependent drop down lists containing unique distinct values - Excel 365 Create dependent drop down lists […]
Table of Contents Create dependent drop down lists containing unique distinct values - Excel 365 Create dependent drop down lists […]
Populate drop down list with unique distinct values sorted from A to Z
Question: How do I create a drop-down list with unique distinct alphabetically sorted values? Table of contents Sort values using […]
Question: How do I create a drop-down list with unique distinct alphabetically sorted values? Table of contents Sort values using […]