bamboo1975
New Member
- Joined
- Apr 10, 2019
- Messages
- 11
- Office Version
- 2013
- Platform
- Windows
Hi, I have cells with data like below in a column. I wonder, can anyone help me with a macro to search and find any two consecutive cells with over 10 minutes difference and highlight them in yellow? Much appreciated.
<colgroup><col></colgroup><tbody>
</tbody>
05/03/2019 06:34 |
05/03/2019 06:57 |
05/03/2019 07:16 |
05/03/2019 07:19 |
05/03/2019 07:25 |
05/03/2019 07:29 |
05/03/2019 07:53 |
05/03/2019 07:57 |
05/03/2019 08:01 |
05/03/2019 08:05 |
05/03/2019 08:07 |
05/03/2019 08:22 |
05/03/2019 08:23 |
05/03/2019 08:23 |
05/03/2019 08:23 |
05/03/2019 08:25 |
05/03/2019 08:25 |
05/03/2019 08:26 |
05/03/2019 08:27 |
05/03/2019 08:36 |
<colgroup><col></colgroup><tbody>
</tbody>