Conditional formatting, and compare target date to NOW()

izwiz wrote:

Hi

I'm trying to help my boyfriend, on his worksheet he has got a target date
column and what he wants it to do is when the date of target date has passed
the font to automatically change colour. I have tried several different
things but without much luck. I would be really grateful if someone could
help me with the formula.

thanks