Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Must Answer Data Validation Question
Hello The data validation box has three answers, blank space, Yes, No)
The answer must be either yes or No but they must answer the question. What do I do so that the question is answered and not skipped? thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Must Answer Data Validation Question
I use an adjacent cell that's formatted in a big, bold, red font.
=if(a1<"","","<-- Please answer this question") But why would you allow 3 answers in your data|validation list. You could just use Yes and No, but it won't stop users from clearing the cell. But it will stop them from choosing the blank. Wanna Learn wrote: Hello The data validation box has three answers, blank space, Yes, No) The answer must be either yes or No but they must answer the question. What do I do so that the question is answered and not skipped? thank you -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Must Answer Data Validation Question
Thanks Dave
This works fine. I use the blank so when the form is opened this particular question does not have an answer but for some reason people tend to skip this question. I have some rows hidden, and depending if the answer Yes or No then the rows that apply will unhide. I do not want this question to be skipped. Is this the right way to do it ? Again Thanks "Dave Peterson" wrote: I use an adjacent cell that's formatted in a big, bold, red font. =if(a1<"","","<-- Please answer this question") But why would you allow 3 answers in your data|validation list. You could just use Yes and No, but it won't stop users from clearing the cell. But it will stop them from choosing the blank. Wanna Learn wrote: Hello The data validation box has three answers, blank space, Yes, No) The answer must be either yes or No but they must answer the question. What do I do so that the question is answered and not skipped? thank you -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Must Answer Data Validation Question
You can select that cell and hit the delete key to clear the contents.
Personally, I don't like using space characters to make the cell look empty. Formulas that depend on that cell need to be cleaned up. =if(or(a1="",a1=" ",a1=" ", ...... or =if(trim(a1)="", ... to avoid the person who hits the space bar lots of times. But I would use the adjacent cell with the warning--and even shade (or use format|conditional formatting) to show that input cell in a different color until it's filled in. Wanna Learn wrote: Thanks Dave This works fine. I use the blank so when the form is opened this particular question does not have an answer but for some reason people tend to skip this question. I have some rows hidden, and depending if the answer Yes or No then the rows that apply will unhide. I do not want this question to be skipped. Is this the right way to do it ? Again Thanks "Dave Peterson" wrote: I use an adjacent cell that's formatted in a big, bold, red font. =if(a1<"","","<-- Please answer this question") But why would you allow 3 answers in your data|validation list. You could just use Yes and No, but it won't stop users from clearing the cell. But it will stop them from choosing the blank. Wanna Learn wrote: Hello The data validation box has three answers, blank space, Yes, No) The answer must be either yes or No but they must answer the question. What do I do so that the question is answered and not skipped? thank you -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Question | Excel Discussion (Misc queries) | |||
Data Validation Question | Excel Discussion (Misc queries) | |||
Data Validation Question | Excel Worksheet Functions | |||
Data Validation question | Excel Worksheet Functions | |||
Data validation question | New Users to Excel |