Yes, I am being very dumb tonight.

I cannot think for the life of me how to do this by conditional format and it's so frustrating.

Basically I have a cell with a date in it. I need the cell to change colour when it's 3 days before the date - in other words, a flagging system to let me know that something is coming up and needs actioning in 3 days.

What would I enter in conditional format?

Thanks.