Conditional Formatting with Date/Time

  • I am no slouch at Conditional Formatting, but this one has me stuck. I am trying to create a sheet that tracks when my shipments are scheduled to arrive, actually arrive, and how soon we unload them.


    My cell column c is scheduled, d arrival, e unload. Each will contain a value in this format 2/15/17 6:30PM. What I need is if Scheduled Column C is 2/15/17 6:00PM and arrival is 2/15/17 and anytime after 6pm I need to highlight red.
    As well if the column with the unload time is greater than 2 hours after the arrival time I need it to be orange. I am pretty sure if I could figure out how to do one I could make the other work. Any help would be greatly appreciated. I have been on google for about 3 hours..

  • Re: Conditional Formatting with Date/Time


    Should throw this in there, I can't put date and time in separate box, if I have a scheduled of 2/15/17 @11PM and it arrives 2/16/17 at 12:01am itll appear early

  • Re: Conditional Formatting with Date/Time


    See if these will work for you.
    Conditional formatting for:
    Column D: =D6>C6
    Column E: =E6>D6+0.08375

  • Re: Conditional Formatting with Date/Time


    No it didnt. I need the entire column E to do it. I am going to try and upload what I have. THere is a formula I have working but I cant make it work on the whole column.



    Quote from Flyboy65;785980

    See if these will work for you.
    Conditional formatting for:
    Column D: =D6>C6
    Column E: =E6>D6+0.08375

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!