In D11 select Data validationCustom and copy paste the below formula

=AND(A11="Day shift",D11<"",MEDIAN("07:00 AM",D11,"06:00 PM")=D11)

If this post helps click Yes
---------------
Jacob Skaria


"Barbara T" wrote:

Hi!

I am trying to set up a spreadsheet where I use data validation to restrict
certain cells to only allow times within a specified range (e.g., 7:00AM to
6:00PM) but ONLY when another cell (A11) contains "DAY SHIFT". If that other
cell (A11) does NOT contain "DAY SHIFT" then I want the validated cells to
still allow only times to be entered but to allow ANY time to be entered.

Is there a way to set this up? I can't see how to restrict when the data
validation occurs when the restrictions are based on TIME.

Thanks so much for any insight you can give!!

Barbara