in a separate column?
=IF(A2="Done",IF(B2="","Date required",""),"")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Michael S." wrote in message
...
Column A = Job Status
Column B = Date Completed
What I would like to have is if Column A = Done and Column B has no value,
I
need to have a warning or a pop up of some kind stating that Column B
needs
to have a date value when column A = Done.
Thank you in advance.
|