Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict entry in one cell based on second cell
Hi Carol,
Try this. I have assumed your data starts in Row 2 Select all the data in Col A In data valadation, select Custom In the formula box enter: =IF($B2<"","") Click OK Select all the data in Col B In data valadation, select Custom In the formula box enter: =IF($A2<"","") Click OK Hope this helps. Regards - Dave. "Carol Sitea" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restrict cell entry until another cell has random text | Excel Discussion (Misc queries) | |||
restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
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 |