Conditional formatting - date entry needs to changes status of record
I have an entry field fort a drop down calendar to record a date when an item or record has been closed. I'd like data entry in this field to change a records status to "closed". The status field is a drop down menu with he choice of "open" or "closed". What is the conditional formatting for this field?