title: Conditional Formatting to reflect Countifs
body: <p>I am using Excel2010 and I have the following Countifs statement, which works.</p>
  
  <pre><code>=COUNTIFS(Apr2014Fixed!$T:$T,"1",Apr2014Fixed!$Q:$Q,"*No*",Apr2014Fixed!$R:$R,"*Yes*")
  </code></pre>
  
  <p>I want to see which rows in my spreadsheet were counted, so that I can determine whether I've done everything right. I tried conditional formatting with the following formula, but I know I'm not using it properly.</p>
  
  <pre><code>=AND(COUNTIFS(Apr2014Fixed!$T:$T,"1",Apr2014Fixed!$Q:$Q,"*No*",Apr2014Fixed!$R:$R,"*Yes*")=3)
  </code></pre>
  
  <p>I don't understand what value I am looking to highlight. I thought =3 because I want all three conditions to be true for a case to be counted, but this didn't highlight anything. When I tried >3, it highlighted the entire spreadsheet. </p>
  
  <p>Obviously, I have no idea how this works? Can anyone help, please?</p>