My cell formula, =IF(OR(B61<>"",C61<>"",D61<>""),"When Approved, Enter Commit Date","") appears to be working fine. I get the message in the cell when criteria is met. And I have a data validation on cell M61 to ensure I get a good date for that cell. When a bad date is entered into cell M61, the validation works perfect and the User is prevented from entering a bad date. The problem is:
When a User hits the "DELETE" key, the formula message is erased. Or, when a User enters a valid date and then decides to delete the date (using DELETE key), the cell is now empty and no longer displays the formula message. My intent is to either have my formula message in the cell, or, have a valid date in the cell. Can someone help?
Bookmarks