Hi everyone!
I need a bit of help with the formula below. I need to solve 3 time-frames and after that to use conditional format to display 3 different colors.
So, the problem is like:
I have a cell with arrival houre, one with maximum departure hour and the final one with the status.
I used the formul below to fill the status with green or red color "=IF(W4<=X4,"on time","delay")"
If the arrival hour is smaller than the maximum departure hour, display on time with green in the status cell, if not delay with red.
The problem i have, i need one mode color, yellow for example. If my truck arrives 2 hours in advance, display "on time", if more than 2hrs display "early" with a diffrent color.
Thank you
Bookmarks