title: Conditional formatting on visible range?
body: <p>I have a table with times of actions and I want to highlight rows that are more than 20-ish minutes more than the one above.<br>
  The actual number of minutes is less important.  </p>
  
  <p>For that I use conditional formatting with the formula:<br>
  <code>=F3-F2&gt;0,01766</code></p>
  
  <p><a href="https://i.stack.imgur.com/wWFdW.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wWFdW.jpg" alt="enter image description here"></a></p>
  
  <p>So far so good.<br>
  But now if I apply filter on the table the the formula does not work anymore  because it looks at the hidden rows.<br>
  Only the first highlight is made by the conditional formatting the other two are done by me.  </p>
  
  <p><a href="https://i.stack.imgur.com/iEJeW.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iEJeW.jpg" alt="enter image description here"></a></p>
  
  <p>Is it possible to get conditional formatting to look at the visible rows only?</p>