View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JPG
 
Posts: n/a
Default Traffic Light Filter On Dates

Hi following previous guidence I need advice on developing filters for
Conditional Monitoring to discriminate between:
Date One earlier than or equel to Date Two - condition green;
Date One earlier than or equel to Date Three - condition green;
Date One later than Date three & Date three earlier than Date two -
condition Red;
Date One later than Date Three & Date Three later than Date Two - condition
Amber. Where Date One is the schedule date; Date Two is the Data date; & Date
Three baseline date. Dates One & Three are different for every occurance and
Date Three is fixed for every period.