I do understand that my current rule will not solve the problem with the expiration date. I would like to set up a rule that when the date goes beyond September 30, the cell turns red. For instance, if someone were to take a course on August 1, 2015 that is what would be entered into the cell. When we reach any day after September 30, it would turn red. I do not want the cell to turn red after August 1 like my current rule is set up for.
Is there a rule that can be set that says the cell should be turned red when the date in the cell goes beyond a specific month and day?