I know this post is over a year old but I found it tremendously helpful in
formatting a project coming up due and then when it was overdue. Thanks!

"Carim" wrote:

Hello Pascale,

Something along these lines ...
Choose Formula Is
and add following formula :

=(TODAY()-B2)=7

HTH
Cheers
Carim