Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I have created a data validation for Cell H16 to make sure that the value in that cell is A, B or C. It works, but it does not check for case sensitivity. How can I make it to check to make sure that it checks for upper case, in addition to the correct value in that cell? I use "Custom" Data Validation, and below is the formula I use. =OR(H16="A",H16="B",H16="C") Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation Question? | Excel Worksheet Functions | |||
Data Validation Question | Excel Discussion (Misc queries) | |||
Data Validation question | Excel Worksheet Functions | |||
DataValidation Question | New Users to Excel | |||
Another Data Validation question | Excel Discussion (Misc queries) |