conditional formatting deadlines

Hi - I have a worksheet with a column (m7:m40) containing dates of reviews
that have taken place. I want to conditionally format it so that dates that
are a year ago or more are highlighted. Any ideas? Many thanks

This doesn't quite cope with leap years, but if you put the following formula into the conditional formating, this should work:-

=IF(TODAY()-M7<365,FALSE,TRUE)

hi
Cell Value | is less than | =now()-365

>-----Original Message-----
>Hi - I have a worksheet with a column (m7:m40) containing
dates of reviews
>that have taken place. I want to conditionally format it
so that dates that
>are a year ago or more are highlighted. Any ideas? Many
thanks
>.
>