Thanks, but you looked at the incorrect file. It was my fault as I added both in error.
On the one I've attached again below, Column F has the date the response is received. As this is exceeds 14 days and it does not appear to have been assessed (no date in column G), I would like the date text (in column F) to turn red.
I don't want the cell in column G to turn red.
The date in column F would then return to black once a date is added into column G.
I hope this makes sense.
Bookmarks