title: Modify Conditional Formatting 'AppliesTo' Range
body: <p>I have a sheet (lets call it <code>Sheet1</code>) which has two existing Conditional Formatting rules. Which apply to a range in column H. The data in <code>Sheet1</code> is deleted and new data is input via a database connection. This deletion and retrieval of data means the <code>RANGE</code> that the conditional formatting applies to changes. Is there a way I can update the CF formatting <code>RANGE</code> (in the <code>Applies to</code> box) without deleting it and recreating it in code?</p>
  
  <p>pseudo-code would be something like</p>
  
  <pre><code>With Sheets("Sheet1")
  .Cells.FormatConditions(1).AppliesTo = "H4:H" &amp; .Range("H" &amp; Rows.Count).End(xlUp).Row
  .Cells.FormatConditions(2).AppliesTo = "H4:H" &amp; .Range("H" &amp; Rows.Count).End(xlUp).Row
  End With
  </code></pre>
  
  <p>Any help would be appreciated, 
  Many Thanks
  Caleeco</p>