Two types of Data Validation in a cell?
This is what I already have. If the user uses the drop down to select Y or N,
then it works properly. However, a user can manually enter lowercase y or n,
and I want to avoid that.
"ryguy7272" wrote:
Data Valivation List Source = =$B$1:$B$2
In Cell B1, put Y and in Cell B2, put N
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"Lakeville" wrote:
I want to ensure that the data in a cell is either a capitalized Y or a
capitalized N. I understand how to do the data validation of a list with Y &
N. And I understand how to enforce capitalization: =EXACT(A1,UPPER(A1)).
However, I don't understand how to enforce both for the same cell.
|