**Question description:**

*This user has given permission to use the problem statement for this
blog.*

Hello, I need help with conditional formatting. My issue: I have a delivery schedule that I need to track. If the order is created between 00:41 and 01:40, delivery time must be by 02:55. If the order time is between 01:41 and 02:40, delivery time must be by 03:55, and so on throughout the day 24hr. I need help creating a format that will highlight anything delivered past its scheduled time . Thanks.

Solved by B. J. in 26 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
05/04/2018 - 06:29

Hi

Excelchat Expert
05/04/2018 - 06:29

Welcome to Got it Pro

User
05/04/2018 - 06:29

Hello

Excelchat Expert
05/04/2018 - 06:30

Can you please share your excel sheet

User
05/04/2018 - 06:31

This is the end result, but I can have 75 to 100 lines to search through to get this result

Excelchat Expert
05/04/2018 - 06:31

Which column you would like to compare.

User
05/04/2018 - 06:32

B to E

Excelchat Expert
05/04/2018 - 06:32

can you please explain your requirement

Excelchat Expert
05/04/2018 - 06:33

For example row number 5 : 16:23 is creation time and your deliver time should 17 :55 but it delivered at 18:42 so its wrong

User
05/04/2018 - 06:33

If an order is created by the :40 of an hour it must be delivered by the :55 of the next hour

Excelchat Expert
05/04/2018 - 06:34

ok

User
05/04/2018 - 06:34

so if the order is created between 00:41 and 01:40, it must be delivered by 02:55

Excelchat Expert
05/04/2018 - 06:34

ok.

Excelchat Expert
05/04/2018 - 06:36

I will work and get back to you

Excelchat Expert
05/04/2018 - 06:36

Just give me 5minuts

User
05/04/2018 - 06:36

Thank you

Excelchat Expert
05/04/2018 - 06:40

if it is less than 40 minutes

Excelchat Expert
05/04/2018 - 06:40

for example first ticket received 4:28 is what will be the due time

User
05/04/2018 - 06:40

05:55

Excelchat Expert
05/04/2018 - 06:41

> 40 minutes correct

Excelchat Expert
05/04/2018 - 06:41

12:40 to 1:40 should be delivered at 2:55

Excelchat Expert
05/04/2018 - 06:41

ok. I got it.

User
05/04/2018 - 06:41

12:41 to 01:40 =02:55

Excelchat Expert
05/04/2018 - 06:42

ok

Excelchat Expert
05/04/2018 - 06:42

3:41 to 4:40 = 5:55

User
05/04/2018 - 06:42

Correct

Excelchat Expert
05/04/2018 - 06:43

5:41 to 6:40 = 7:55?

User
05/04/2018 - 06:43

Correct

Excelchat Expert
05/04/2018 - 06:43

ok got it

User
05/04/2018 - 06:44

We are 24/7, so it never stops

Excelchat Expert
05/04/2018 - 06:46

ok. let me share the file

Excelchat Expert
05/04/2018 - 06:47

Check this

[Uploaded an Excel file]

Excelchat Expert
05/04/2018 - 06:48

Is it working?

Excelchat Expert
05/04/2018 - 06:51

Are you there?

Excelchat Expert
05/04/2018 - 06:52

???

User
05/04/2018 - 06:54

Sorry, It looks like it's working

Excelchat Expert
05/04/2018 - 06:54

Ok Super.

Excelchat Expert
05/04/2018 - 06:54

If you want download the screen file as well for your reference.

User
05/04/2018 - 06:54

Thank you very much for your help

Excelchat Expert
05/04/2018 - 06:54

Please provide your valuable feedback and remarks.

Excelchat Expert
05/04/2018 - 06:55

your always welcome :)

Excelchat Expert
05/04/2018 - 06:55

Please end the session to support other users.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*