We have a spreadsheet containing closing dates. We'd like the closing date
field on a row to turn red once the closing date has passed (i.e. today is
later than the closing date).

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

Can anyone help please?