Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Advanced filter using dates | Excel Discussion (Misc queries) | |||
filter dates in data range | Excel Worksheet Functions | |||
Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
how to filter dates? | New Users to Excel | |||
FILTER OUT DATES IN LIST | Excel Worksheet Functions |