I have set conditional formatting to change the color of a date in a cell
that is within +/- 14 days of today's date. However, I'd like to turn off
(automatically) the conditional format if the cell is subsequently
highlighted (this means that the task has been completed, so there's no need
for the "reminder" formatting).

Any ideas?
--
P Walsh