Traffic Light Filter On Dates

J

JPG

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.
 
B

Bryan Hessey

The formula


=IF(OR(A2<=B2,A2<=C$1),"Green",IF(AND(A2>C$1,C$1<B2),"Red",IF(AND(A2>C$1,C$1>B2),"Amber","Unspecified")))

is as per your request, with Date 3 in C1 and dates 1 & 2 in A2 & B2
etc.

Hope this helps

--
 
Top