Need help on Data Validation

Hello all,

I will not be adding all of the details to save time but if anything more is needed, please let me know. So here is my issue: I am creating a mixing schedule for my Cosmetics Department. The headers I am stuck on are the "Status" column and the "Stop Time" column. The status column will show where in the mixing process the mixer is at. The Stop time column will show what time the mix was completed at.

I would like to have a drop down list, using data validation, to the "Status" column with the following options: Scheduled, Pending, Delayed, Running, Finished. (Finished my change to "Completed". Still undecided) <-This is completed.

I would like to have the "Finished" option, only able to be selected if the "Stop Time" column has a time inputted. Otherwise, I would like an error to pop up say "Finished option only available if "Stop Time" has value" or something along those lines.


Is this possible?

Thank you! I've updated the Excel version on my profile!

Is the sample workbook a requirement?

Oh wow...HAHA a simple IF with true and false. I appreciate it. My issue was I was trying to include All of the options in the dropdown list with an error showing if finished was selected without a value in the Stop column but I see, why over-complicate things. Thank you very much!


This will work. I am still curious though about the method I was asking about. Maybe I could just have an error box pop up when the cell is clicked on? I think that would accomplish the same thing.

Thanks again!

Create named range for "Finished" and "List", then in the Data Validation, use "List" and put formula under "Source": =IF(B2<>"",Finished,List)