View Single Post
  #2   Report Post  
 
Posts: n/a
Default

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
.