Dear friends,

i've inserted modules from http://www.cpearson.com/excel/CFColors.htm,
however i failed to get any of the function working - even
=ColorOfCF(A1,FALSE). and i hope to gain support from you.

i am using excel 2007. cells were formatted on conditions using the
conditioning format button available at the top panel (under home
tab). will that be a problem?

there're more than a thousand rows and not all of them are formatted
under the same condition.

my goal is to count the cells of the same color, i guess i have to use
=CountOfCF(..)

look forward to your reply.

best regards,
maggie

On Jul 15, 5:04*am, Maggie Lau <maggie...@gmail.com> wrote:
> Dear friends,
>
> i've inserted modules fromhttp://www.cpearson.com/excel/CFColors.htm,
> however i failed to get any of the function working - even
> =ColorOfCF(A1,FALSE). and i hope to gain support from you.
>
> i am using excel 2007. cells were formatted on conditions using the
> conditioning format button available at the top panel (under home
> tab). will that be a problem?
>
> there're more than a thousand rows and not all of them are formatted
> under the same condition.
>
> my goal is to count the cells of the same color, i guess i have to use
> =CountOfCF(..)
>
> look forward to your reply.
>
> best regards,
> maggie

What happens when you try to use the functions?
Do you see: #NAME?
or
Do you see an incorrect value?

On Jul 15, 10:42*pm, James Ravenswood <james.ravensw...@gmail.com>
wrote:
> On Jul 15, 5:04*am, Maggie Lau <maggie...@gmail.com> wrote:
>
>
>
> > Dear friends,
>
> > i've inserted modules fromhttp://www.cpearson.com/excel/CFColors.htm,
> > however i failed to get any of the function working - even
> > =ColorOfCF(A1,FALSE). and i hope to gain support from you.
>
> > i am using excel 2007. cells were formatted on conditions using the
> > conditioning format button available at the top panel (under home
> > tab). will that be a problem?
>
> > there're more than a thousand rows and not all of them are formatted
> > under the same condition.
>
> > my goal is to count the cells of the same color, i guess i have to use
> > =CountOfCF(..)
>
> > look forward to your reply.
>
> > best regards,
> > maggie
>
> What happens when you try to use the functions?
> Do you see: *#NAME?
> or
> Do you see an incorrect value?

thanks for your reply.

"#NAME" always appeared, probably i was not using the function
correctly?