View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Please Help[_2_] Please Help[_2_] is offline
external usenet poster
 
Posts: 9
Default Data Validation Question

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.