We found Chip Pearson's site: http://www.cpearson.com/excel/CFColors.htm with
some code that is supposed to count the cells with conditional formatting
applied. But we can not get it to work. What are we missing????

We are trying to use this:
CountOfCF
This function return the number of cells in a range that have a specified
conditional format applied. Set the last argument to -1 to look at all format
conditions, or a number between 1 and 3 to specify a particular condition.
This function requires the ActiveCondition function. You can call this
function directly from a worksheet cell with a formula like:
=CountOfCF(A1:A10,1)

We have that function in a module in the workbook. We also have the code for
the Active Condition Function and the GetStripped Function pasted in the same
module.

In the cell where we want the count to appear, we enter the CountofCf
function with the range and the number of the Conditional Formatting
condition. We either get a 0, when there should be a number, or we get a
circular reference, even though the cell with the formula is not listed in
the range.

Any ideas what we might be doing wrong?
--
maryj