title: String in a conditional formatting formula in vba
body: <p>I want to format column G if column D has "AI" in the same row using VBA in Excel 2007.</p>
  
  <p>If i do it manually in the conditional formatting editor the formula <code>=(D1 = "AI")</code> works correctly.</p>
  
  <p>If i try to add this formula to the Formula1 clause of a FormatConditions.Add method i must put
    <code>="(D1 = ""AI"")"</code> or the interpreter complains. But this is copied literally with the doubled double quotes as the condition and the formatting does nothing.</p>
  
  <p>What should I put in Formula1 ?</p>
  
  <p>Antonio</p>