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
Bookmarks