Hi all, hope someone can help with this - it's driving me crazy.

Have a straight forward list of cells, name, address, company name etc,
which requires the user to type in text or select from a drop down list to
complete. Simple enough. I have the following formula which appears in a
separate box if any of the required fields are left blank. However, when a
user first enters the sheet, this message appears automatically because all
the fields are already blank.

=IF(OR(B3="",B5="",B7="",B9="",D9="",B11="",B13="" ,B15=""),"Please ensure
all fields are completed","")

What I would really like to do is have this message appear at the end of
non-completion of cell B15 rather than be visible all the time.

Hope someone can help.

Many thanks.