You could use a column that indicates an error--maybe a new column A.

=if(counta(b2:G2)=6,"","Please fill in all the cells!")
(and give it a nice big, bold red format)

Apply data|filter|autofilter to that column and the user could even filter to
show non-blanks to see the problem rows.



Edward wrote:

I'm not an Excel expert so please be gentle with me.

I've been asked to design a form to enter data that will later be used
in a SQL Server DTS package to populate a database.

I've restricted the worksheet to only certain cells, and used drop-
down lists where possible. What I really want to do is to try to
ensure that users enter ALL required data - i.e. if they enter data on
a row they put something in all the required columns.

I could use a button and VBA to achieve this, but I think the client
would rather I didn't (for security reasons: the worksheet will be
circulated to many hundreds of employees). Can anyone think of any
nifty tricks to ensure data is entered where required?

Many thanks

Edward

--

Dave Peterson