In my previous post I showed how to have a flexible data validation and how to validate it. This post will look at adding conditional formats to inputs and validations.
The most common type of Data Validation in Excel is a drop down list. In the example below I allow the user to select a year, then a month (using a drop down) and then enter a valid day in the month.
You can create a hyperlink to another Excel file in Excel but you can’t control what sheet or cell will be active. Well you can actually, but you need to know how.