<div>
Your solution corrected the issue. Thanks!!
</div>


<div>
<div class="content wysiwyg-content">
Regarding this formula:<br />
=&quot;# of Partials: &quot;&amp;COUNTIF(X6:X2006,&quot;AND(X6<wbr />&gt;=1,X6&lt;=(W<wbr />6-1))&quot;)<br />
<br />
Not getting any error messages but does not make a count either.<br />
<br />
Being used as a formula in conditional formatting. Works fine for changing cell color, when condition true, but does not make a count.<br />
<br />
I am probably missing the obvious...<br />
<br />
Thanks in advance
</div>
</div>


Regarding this formula:
="# of Partials: "&COUNTIF(X6:X2006,"AND(X6>=1,X6<=(W6-1))")

Not getting any error messages but does not make a count either.

Being used as a formula in conditional formatting. Works fine for changing cell color, when condition true, but does not make a count.

I am probably missing the obvious...

Thanks in advance

Conditional Formula Question.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.