Okay, now I have a clearer idea of what you are wanting, there are a variety
of ways you can do this, I'll provide 1 for you that is fairly basic. I am
referencing cells that you used in earlier questions.
Cells that require data: B3, B5, B7, B9, D9, B11, B13, B15
Say you want your statement, you have "Please ensure all fields are
completed", I am going to use something slightly different.
We have 8 cells that need to be filled, first, I want to define a variable
that actually counts how many of the cells have data.
Insert|Name|Define
Name will be DataFill (change to what suits your needs).
This will be defined as:
=(B3<"")+(B5<"")+(B7<"")+(B9<"")+(D9<"")+(B11 <"")+(B13<"")+(B15<"")
Each expression evaluates to 0 or 1, 0 if the cell is blank (or appears
blank), and 1 if there is 'something' in the cell (be it typed, or picked up
from a list or 'calculated').
Then, in the cell that you want your statement to appear (B19)???? type the
following formula:

=IF(OR(DataFill=0,DataFill=8),"","You have " & 8-DataFill & " more fields to
complete for quote")
You could still do this:
=IF(OR(DataFill=0,DataFill=8),"","Please ensure all fields are completed")

Both of these formulas will display the 'response' as soon as any field is
filled, and remove the response once all the fields are filled.

Hope this helps.
--
John C


"GillianX" wrote:

Hi,

I'm struggling still with a problem I have. It seems simple enough but as
I'm fairly new to working with spreadsheets, I can't figure it out.

You know when you complete say, an online order form and if you haven't
completed a field you get asked to fill it in? Well, I have to create
something similar. My data is to be inputted by a user, basic stuff like Your
Name, Your Company that type of thing. For a quote to be calculate though,
all fields have to have either text or numbers or an option selected from a
drop down. What I would like to happen is that a "Please ensure all fields
are completed" box appears when a field or fields are left blank. I don't
want the box to appear when the worksheet is opened, only after one or a
number of fields are not completed.

I hope this makes sense and I hope someone can help me out.

Thanks