We have a spreadsheet with closing dates on it. We'd like the closing date
field's pattern to turn red when today after the closing date.

BUT, once a date is input into another field along the same row, we'd like
the first field to revert to its original colour.

Can anyone help please?