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." <MichaelS@discussions.microsoft.com> wrote in message
news:EFBFF095-534D-4E44-9EF3-C2C88E5A0E56@microsoft.com...
> 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