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

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
.