change font colour after a date has expired
 

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

change font colour after a date has expired
 

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