Conditional formatting for multiple loop

[getsanskarsingh]

Hello Guys,
I have sheet in which one order is repeating with changing its outcome. So, I want to apply conditional formatting for that particular order if there is difference between next outcome & first outcome, not more than 30 minutes.
Please tell me VBA code regarding this

 

[Joe4]

Welcome to the Board!

Without knowing the structure of your data, it is difficult to give you any sort of specific instruction.
Can you post a small sampling of your data?

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[getsanskarsingh]

For Example,

I have complaint order ID-xyz which was updated in tracker at 01-June-2018 10:12 & outcome is pending action 1. After some time It was updated as pending action 2 at 10:41 same day & next it was updated as resolved at 11:13 same day.
So, I wanted to know that If there is difference between these timings is more than 30 minutes then the next cell will change the color ??

 

[getsanskarsingh]

Hi Team,
Please see this data & id- 4438066482,
its not actual one.


S.n Complaint ID Outcome Timestamp

1 4438066482 Unassinged 06-05-18 10:48
2 4438707192 06-05-18 10:54
3 4438753782 06-05-18 11:03
4 4438066482 PENDING 1 06-05-18 11:44
5 4433674242 06-05-18 13:38
6 4438066482 PENDING 2 06-05-18 12:44
7 4433603722 06-05-18 12:09
8 4432275033 06-05-18 13:29
9 4438066482 Resolved 06-05-18 13:49
10 4430198931 06-05-18 14:51

 

[Joe4]

Are we looking strictly at time, or does the Complaint ID need to be considered too (so we are checking for time changes of less than 30 minutes for particular Complaint IDs).
If so, it looks look they are not in Complaint ID order. Can we first sort by Compliant ID and then Timestamp? Is that OK?

If we are just looking at Time changes, regardless of Complaint ID, can we sort by that field first (the example is not in TimeStamp order either)?