Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
restrict entry in one cell if there is anything in the cell next t
I need to restrict entry in one cell if there is anything in the cell next to
it. Only one entry per line. How can I do this? Thanks in advance, Carol A B Fed Other 1 1 2 1 3 1 4 1 5 3 6 2 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
restrict entry in one cell if there is anything in the cell next t
You need Validation on the Data toolbar.
Data Validation, in the 'Allow' box, select 'Custom' In the 'Formula' box that appears, enter =B1=0 Use the Error Alert tab to enter a suitable error message, Regards, Alan. "Carol Sitea" wrote in message ... I need to restrict entry in one cell if there is anything in the cell next to it. Only one entry per line. How can I do this? Thanks in advance, Carol A B Fed Other 1 1 2 1 3 1 4 1 5 3 6 2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
restrict entry in one cell if there is anything in the cell next t
I should have said, do this in cell A1,
Alan. "Alan" wrote in message ... You need Validation on the Data toolbar. Data Validation, in the 'Allow' box, select 'Custom' In the 'Formula' box that appears, enter =B1=0 Use the Error Alert tab to enter a suitable error message, Regards, Alan. "Carol Sitea" wrote in message ... I need to restrict entry in one cell if there is anything in the cell next to it. Only one entry per line. How can I do this? Thanks in advance, Carol A B Fed Other 1 1 2 1 3 1 4 1 5 3 6 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restrict entry in one cell based on second cell | Excel Discussion (Misc queries) | |||
Restrict cell entry until another cell has random text | Excel Discussion (Misc queries) | |||
lock cell conditional format but not restrict data entry | Excel Worksheet Functions | |||
How can I restrict a cell(s) to alpha-only data entry? | Excel Discussion (Misc queries) | |||
How do I restrict entry into a cell to only alpha/numeric? | Excel Worksheet Functions |