| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a specific cell mandatory?
Can a specific cell be locked and made mandatory entry to "unlock" entry into
other cells? It will be the first piece of information entered into a spreadsheet and can't be skipped. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make a specific cell mandatory?
Lets say the cell A1 must have something in it before you can put anything in
B1. Select cell B1 and then from the Data menu select Validation - Custom - Formula =A1<"". Uncheck Ignore Blanks and then hit OK. You now can not enter anything in B1 until A1 has a value in it. You will probably want to change the message to the user explaining that A1 is mandatory. -- HTH... Jim Thomlinson "soday" wrote: Can a specific cell be locked and made mandatory entry to "unlock" entry into other cells? It will be the first piece of information entered into a spreadsheet and can't be skipped. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I make a specific cell mandatory?
Lets say the cell A1 must have something in it before you can put anything in
B1. Select cell B1 and then from the Data menu select Validation - Custom - Formula =A1<"". Uncheck Ignore Blanks and then hit OK. You now can not enter anything in B1 until A1 has a value in it. You will probably want to change the message to the user explaining that A1 is mandatory. -- HTH... Jim Thomlinson "soday" wrote: Can a specific cell be locked and made mandatory entry to "unlock" entry into other cells? It will be the first piece of information entered into a spreadsheet and can't be skipped. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make an input in a cell mandatory without leaving it blank | Excel Discussion (Misc queries) | |||
| how to make a cell mandatory in the excel sheet | Excel Worksheet Functions | |||
| How can I make a cell mandatory? | Excel Discussion (Misc queries) | |||
| How can I make a cell mandatory and only accept a Y or N? | Excel Worksheet Functions | |||
| Can I make cell completion mandatory in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
