Set Up Case-Sensitive Text Validation in Excel: UPPERCASE, lowercase, Proper Case 

In this tutorial, we'll show you how to use Data Validation in Excel to ensure that text entered into your spreadsheet meets specific case requirements. Learn how to set up your sheet so that the first column only accepts lowercase letters, the second column only accepts uppercase letters, and the third column only accepts proper case.