Dear Sirs,
I have Excel 2007 and I need a solution to put some restrictions for some fields until filling some another fields first,
ex.: I can't fill A2 before fill A1.
Thanks in advance for all helpers..
Dear Sirs,
I have Excel 2007 and I need a solution to put some restrictions for some fields until filling some another fields first,
ex.: I can't fill A2 before fill A1.
Thanks in advance for all helpers..
You can use data validation option. Select A2. Go to data validation --> Allow: Custom --> Formula: =A1<>0 .
Uncheck the "Ignore blank" checkbox.
DEEPLY THANKS Sindhus for your assist...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks