View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Allan Skyner Allan Skyner is offline
external usenet poster
 
Posts: 1
Default Conditional formatting dates due to expire

I have a column in a spreadsheet which lists the various dates a lease will
expire. What I would like to do is to change the format to yellow when the
date is due in 90 days, (in other words give me a 3 month warning), and
change to red when the date is reached and past. All the other dates will be
green to signify lease is still current. Thanking anyone in advance.