title: Relative vs absolute address
body: <p>I would like my Formula1:=&quot;=$J10=&quot;&quot;S&quot;&quot;&quot; for a relative address instead of an absolute. It must be A10, how do I write it?</p>
  <pre><code>Sub Makro7()
  ActiveCell.Range(&quot;A1:A31,B1:B31&quot;).Select
  ActiveCell.Offset(0, 1).Range(&quot;A1&quot;).Activate
  Selection.FormatConditions.Add Type:=xlExpression, Formula1:=&quot;=$J10=&quot;&quot;S&quot;&quot;&quot;
  Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
  With Selection.FormatConditions(1).Interior
      .PatternColorIndex = xlAutomatic
      .Color = RGB(255, 0, 0)
      .TintAndShade = 0
  End With
  Selection.FormatConditions(1).StopIfTrue = False
  End Sub
  </code></pre>