Bob,

When I copy the function CFColorCount into my workbook, the following line
displays a compile error

CFColorCount = CFColorCount - _
CLng(CFColorindex(cell, text) ) = ciValue )

What am I missing? I have the CFColorindex function there already.

"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.CFConditions.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"John/Churchwell" wrote in message
...
I have formatted a cell with 3 conditions. What Excel Visual Basic
elements
will let me know which of the 3, if any, conditions were used to format
the
cell.

Bradc