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

Use a new column with a check mark or completed date
then condition can work from that

"Araqnid78" wrote:

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