| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
User must enter something in a range of cells
Thanks to all three of you for responding to my question.
I now know how to answer the student's question and apply this information in the future. Thanks again! Jugglertwo "Dave Peterson" wrote: I've found just putting up a warning in an adjacent cell is enough of a reminder for most people. =if(a1<"","","<-- Please fill in this cell!") Jugglertwo wrote: A student asked this question recently and I couldn't figure it out. We were doing data validation and they asked if there is a way to require that a cell have information entered in it and it can't be left blank. I tried several options but couldn't get it to work. Any suggestions using data validation and/or any other Excel features? Thanks for any suggestions! Jugglertwo -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I define a range using values in cells? | Excel Worksheet Functions | |||
| UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Threaded Mode
