I have a question which seems relatively simple around Data Validation.
Column A contains a free text field for a date. Column B, contains a list Data Validation of status. The status drop down options are "Complete","In Process","Cancelled".
The goal is whenever someone selects "Complete" from the status column if there is not a date in column A to have an error message pop up. Can someone please assist? Thank you! (Note this is in Excel 2007)
A B
Date Status
Hi Superman,
I don't believe you could do both with Data Validation (create the drop-down list AND check to see if a date is in column A of that row). For that you could use a worksheet_change even macro like the one below:
Any time you change a value in column B to Complete it will check to see if a valid date exists in column A for that row. If not, the user will get a warning message and the last change will be undone. If yes, the user won't see any message (it will allow them to change the status).
Please Login or Register to view this content.
Hope that helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks