Conditional Formatting Specific Time Window

[fotodude]

Hello Guys,
I'm new to this and I would like to ask you for help.
I have 2 times one is the target time (A) and one is the actual arriving time (B)
I need to to change the color on arrival time if it's either 15 min earlier than the target time or if it's later than the arrival time. Only if it's in between this 15 min it should stay blank or green.
It would be great if it's possible to show orange if it's 20-15 min before target time and 1-5min after the target time.
Red if it's 20 or earlier before target time and 6min and longer after target time.

I attached a workbook to get a better understanding.

Thanks already.
Martin

[Richard Buttrey]

Does the attached help

[fotodude]

Hi Richard,
Sorry for the late reply. Thanks for you help and it works great but the only thing I noticed is that it still shows green even though it's past Target time.
It should only be green 15 min prior target time till exact target time. If it's one minute (1 to 5 min )late it should be orange and starting 6min and later it should turn red.
Also is there any chance if there is a N in column A that we do not check whats before target time and only watch whats after target time. In other words if its before or exact target time it needs to be green,
if it's past target time 1 min - 5 min orange and 6 min and up red.

[JeteMc]

Here is an option, adapted from Richard's.
Green rule formula (Note: Stop if true is checked):

Please Login or Register  to view this content.

Red rule formula:

Please Login or Register  to view this content.

Orange rule formula:

Please Login or Register  to view this content.

Columns E, F and G are not needed, they were used for testing and left for insight as to how the proposed solution works.
Let us know if you have any questions.

[fotodude]

Thanks JeteMc. That's exactly what I needed. Thanks again for your help, Martin

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.