So I have a worksheet which has three date columns,

Column B is received date

Column D is due date

Column F is response date

Column D uses the formula

=WORKDAY(B

x,$S$1)

where S1 just says 10, such that column D displays the due date as 10 working days from the received date of column B.

I have then conditionally formatted column D to highlight dates that are past due with

cell value < NOW()

What I would like to do is once there is a response date in column F, the dates in column D are no longer appearing red.

Is this possible? Column F will be blank until the date is input manually but I can’t get ISBLANK to do anything