Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i create a conditional sum? | Excel Worksheet Functions | |||
conditional formatting conflict? | Excel Worksheet Functions | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |