Thread: Conditional formatting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Conditional formatting
Hello Pascale,

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

=(TODAY()-B2)=7

HTH
Cheers
Carim

Reply With QuoteReply With Quote