Conditional Value
 

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.

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.

In the same column. Column B has to have a date in the cell if Column A =
Done. I do not want users to be able to do anything else until they put the
date of completion in.

I tried the formula you supplied, however I was not able to get it to work.

"Bob Phillips" wrote:

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.

You can throw up a message when they enter Done in A, but it will be very
difficult to force them to do it before anything else.

--

HTH

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


"Michael S." wrote in message
...
In the same column. Column B has to have a date in the cell if Column A =
Done. I do not want users to be able to do anything else until they put
the
date of completion in.

I tried the formula you supplied, however I was not able to get it to
work.

"Bob Phillips" wrote:

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.