View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neal Ostrander Neal Ostrander is offline
external usenet poster
 
Posts: 6
Default Using datedif to format cell color

How can I set the color of a cell based on the difference between the date
entered and todays date. For example if the date entered is equal to 90 days
but greater than 60 days away from todays date I want to color the cell
green.
Thanks in advance for any help.
Neal