View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JonnyP-SC JonnyP-SC is offline
external usenet poster
 
Posts: 1
Default how do i get a date to turn red if it is within 90 days of today?

I use a spreadsheet with lots of dates and need them to automatically turn
red if they are within 90 days of today's date. I believe I need to use
conditional formatting, but am not sure how to set it up correctly.