Good afternoon,
I'm working on a tracker for my company and am looking to force entries into each cell. How can i lock a cell from having any information being entered or drop down selected if the previous cell is left blank?
Thanks in advance.
Good afternoon,
I'm working on a tracker for my company and am looking to force entries into each cell. How can i lock a cell from having any information being entered or drop down selected if the previous cell is left blank?
Thanks in advance.
Hi,
Select cells From A2 to A100.
Click on Data --> Validation.
In the allow dropdown select "Custom".
Make sure that "Ignore Blank" is not checked.
in Formula field type "=not(isblank(a1))"
Done>>>>>>>>>
Shijesh Kumar
http://shijesh.wordpress.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks