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 |
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 |
All times are GMT +1. The time now is 07:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com