change font colour after a date has expired

[izwiz]

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

 

[Bob I]

Conditional formatting, and compare target date to NOW()