View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
loc loc is offline
external usenet poster
 
Posts: 18
Default conditional formula with date

I have a delivery date column with mmm-yy format. How can I write a
conditional formula so that the date turns yellow when it's due in 30 days
and turns red when it's over due? Please help!