View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carol Sitea[_2_] Carol Sitea[_2_] is offline
external usenet poster
 
Posts: 1
Default Restrict entry in one cell based on second cell

I need to restrict entry to a cell if the cell next to it has something in
it. Only one entry per line. I see I can use data validation but not sure
what to put in there!

Thanks in advance for help!
Carol

A B
Federal Other
1 2
2 2
3 2
4 2
5 2
6
7 5
8
9 1