View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 492
Default 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