View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ralph Ralph is offline
external usenet poster
 
Posts: 79
Default Cell color changes when date gets closer

Hi:

I have a large spreadsheet that I track employee training on. The cells
contain the DUE date of next training I would like to format it so that if a
training date is past the DUE date the cell color is "red". If the date is
within 0-30 days the cell is "amber", and if it is within 31-60 days of DUE
date then "yellow".

Many thanks for you help....