I have two columns. In A1 I have a date. In B1 I have the status of a project (Pending, Active, On Hold, Closed, Expired) that is part of a drop down list. Is there a way to have B1 automatically select a status based on the date is is entered in A1? I am really only interested in B1 being selected as "Expired" automatically when a certain date has passed. Otherwise, I want the user to be able to select any of the other choices. However, selecting "Closed" will ignore the date altogether and not change the status to "Expired".