Thread: change color after 60 days
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Carim[_2_] Carim[_2_] is offline
external usenet poster
  
Posts: 97
Default change color after 60 days
Hi,

Use Format conditional formatting
Formula Is
=E1+60<TODAY()
Pattern
Red ...

HTH
Reply With QuoteReply With Quote