title: Access 2010 - Conditional Formatting Many Fields
body: <p>I need to conditional format 24 text boxes with 2 rules each.  Each rule is slightly different, based on the month.  Is there some way I can type my conditional format rules all in one screen so I don't have to click so many buttons?  Plus, this would save considerable time if I even needed to edit the rules.  Psuedocode:</p>
  
  <pre><code>Style1 = FontFill.Red
  Style2 = FontFill.Yellow
  
  txtField1.ConditionalFormatting.Add("&lt;rule text&gt;", Style1)
  txtField1.ConditionalFormatting.Add("&lt;rule text&gt;", Style2)
  
  txtField2.ConditionalFormatting.Add("&lt;rule text&gt;", Style1)
  txtField2.ConditionalFormatting.Add("&lt;rule text&gt;", Style2)
  </code></pre>