title: How to do a Conditional Formatting with hh:mm:ss format on Excel
body: <p>I have two different columns. Each one contains timestamps in <code>hh:mm:ss</code> format, and I want to do a <code>between</code> comparition and check if the Value Colum 2 is between Value Column 1 Row 1 and Value Column 1 Row 2, and then, paint the cell in green, or in red if the condition is not satisfied.</p>
  
  <p>Here my columns:</p>
  
  <pre><code>Column 1     Column 2
  
  16:06:13     16:07:34
  16:06:41     16:08:42
  16:08:39     16:09:49
  16:09:47     16:11:02
  16:10:53     16:12:10
  16:12:08     16:13:40
  16:13:39     16:14:48
  16:14:47     16:16:04
  16:18:06     16:18:06
  </code></pre>
  
  <p>I applied a <code>Conditional Formatting -&gt; HighLight Cell Rules -&gt; Between</code></p>
  
  <p>then from Column 2 Row 1, I selected the first value from Column 1 Row 1 and the next value from Column 1 Row 2, but nothing happens.</p>
  
  <p>Anyone can help me?</p>
  
  <p>Thanks!!</p>