title: Named range in conditional formatting formula
body: <p>I have code like below. And I would like to set named ranges (cells) instead of ranges (cells) H$7 and $G$7. Because if for example I add new column before these cells and recover macro with this code it does not work correctly. Have you got any idea? Thanks in advance  </p>
  
  <pre><code>With Range(SomeRange).FormatConditions _
  .Add(xlExpression, xlFormula, "=((H$7&lt;=$G$7)*((H$7+7)&gt;$G$7))") 
  With .Interior                                                      
       .Color = RGB(197, 217, 241)                                    
  End With
  End With
  </code></pre>