View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Pascale Pascale is offline
external usenet poster
 
Posts: 78
Default Conditional formatting

Hello Carim
THANK YOU VERY MUCH. It works!!!
So what would I put if it were for 2 months

=(TODAY()-B2)=60 ???

"Carim" wrote:

Hello Pascale,

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

=(TODAY()-B2)=7

HTH
Cheers
Carim