conditional cells

G

Gary

We wish to make an employee timesheet with the condition that each required
cell must be completed prior to continuing to the next required cell. For
example, a clients name must be typed in a cell before being able to type in
the date, and then the date must be typed in before being able to type in
hours on the job, etc. Is there a method of accomplishing this type of task
in Excel?

Regards,
Gary
 
E

Earl Kiosterud

Gary,

In the date cell, use Data - Validation - Custom; =A2<>"" Clear the "Ignore blank" box.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already
top-posted, the thread gets messy. When in Rome.
 
G

Gary

Earl,

Thank you for your response. Could you add a little more detail to your
suggestion? I'm not sure what steps to take to accomplish the formula.
Included in the form we are trying to automate are (1) dates (2) text (3)
numbers. Each line must be filled in prior to proceeding to the next line.

Regards,
Gary
 
D

David McRitchie

Hi Gary,
You may be making things very difficult to work with by
someone who is good at entering data. Also Data Validation
can be defeated by pasting, which also wipes out the validation.

To read about "Data Validations" at Debra Dalgleish's site
http://www.contextures.com/tiptech.html
You might also check Dick Kusleika's "Daily Dose of Excel"
http://www.google.com/search?q=site:dailydoseofexcel.com+validation&num=100

In the date cell, use Data - Validation - Custom; =A2<>""
Clear the "Ignore blank" box. [Earl's reply]

A2: client name
B2: Date would have the cell validation =A2<>""
C2: Hours would have the cell validation =B2<>"" or perhaps =NOT(ISBLANK(B2))
A3: client name might have a cell validation checking C2

with very limited description of form, that is the best that
I can add, but you also have data beyond C2 that would be optional
so this could be very complicated for you to design and maintain
and be difficult for data entry if not done properly.

But your new requirement to not enter a new client before the previous
client has been filled in might be a real breaker. ("Each line must be
filled in prior to proceeding to the next line.")


BTW, you should be replying to Earl's reply, not to your original
post in the thread. That way Earl and others, including yourself,
would see that you are replying to his reply (which would also still
be under the thread you began). It would also better reflect the
manner in which you are modifying your question.
 
Top