Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hi
I require that a cell range , say, A1:A23, can only accept, "H","S","Y","N" or "O" and nothing else. The file is 52 sheets and will be applied to all sheets Can this be achieved by conditional formating or has it got to be validation/list etc? thanks in advance brian -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation in a Conditional Statement | Excel Worksheet Functions | |||
Conditional Validation | Excel Worksheet Functions | |||
Data Validation or Conditional Format (or combo of) | Excel Worksheet Functions | |||
Conditional Validation | Excel Worksheet Functions | |||
Conditional validation :-) | Excel Discussion (Misc queries) |