title: Conditional formatting formula
body: <p>I have an OpenOffice Calc sheet containing a number of columns.  Two of the columns are:</p>
  
  <ol>
  <li>D (Gender)</li>
  <li>F (Nationality)</li>
  </ol>
  
  <p>Now, I want to highlight all the records which have Gender=<code>Male</code> and Nationality=<code>UK</code>.  </p>
  
  <p>I tried the following but it did not work:</p>
  
  <pre><code>$D='Male' AND $F='UK'  
  </code></pre>
  
  <p>Can you please provide me an example of a formula which I can use to do this in the Conditional Formatting menu?</p>