Use data validation on A2 with a custom value of =B2<"", assuming row 2,
and an appropriate error message

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Michael S." wrote in message
...
I would like to have a message box display under these conditions.

Column A = Job Status
Column B = Date Completed

If column A = Done and Column B does not have a date of completion then I
would like to have a msgbox pop up and tell the user they need to put a
completion date in column B.

Thank you