count coloured cells

Hi
How can I count cells which are formatted in colour? I have tried the
countif function, but it does not work. I cannot use the conditional
formatting, because the cell values contain only text, which is not
repeating. So I have to manually colour the cells.

Please advise.

ile

See:

http://www.cpearson.com/excel/colors.htm
--
Gary's Student


"ile" wrote:

> Hi
> How can I count cells which are formatted in colour? I have tried the
> countif function, but it does not work. I cannot use the conditional
> formatting, because the cell values contain only text, which is not
> repeating. So I have to manually colour the cells.
>
> Please advise.
>
> ile

Thanks for the help. Unfortunately I'm not that familiar with VB coding. I
copied the code to VB editor, but it didn't work. What am I doing wrong?

Any solutions?

ile

"Gary''s Student" wrote:

> See:
>
> http://www.cpearson.com/excel/colors.htm
> --
> Gary's Student
>
>
> "ile" wrote:
>
> > Hi
> > How can I count cells which are formatted in colour? I have tried the
> > countif function, but it does not work. I cannot use the conditional
> > formatting, because the cell values contain only text, which is not
> > repeating. So I have to manually colour the cells.
> >
> > Please advise.
> >
> > ile

In the VBA Editor, go to the Insert menu and choose Module. Paste
the code in that module.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ile" <ile@discussions.microsoft.com> wrote in message
news:33DC4F38-9BA1-4F34-879C-8E1EBC8B55ED@microsoft.com...
> Thanks for the help. Unfortunately I'm not that familiar with
> VB coding. I
> copied the code to VB editor, but it didn't work. What am I
> doing wrong?
>
> Any solutions?
>
> ile
>
> "Gary''s Student" wrote:
>
>> See:
>>
>> http://www.cpearson.com/excel/colors.htm
>> --
>> Gary's Student
>>
>>
>> "ile" wrote:
>>
>> > Hi
>> > How can I count cells which are formatted in colour? I have
>> > tried the
>> > countif function, but it does not work. I cannot use the
>> > conditional
>> > formatting, because the cell values contain only text, which
>> > is not
>> > repeating. So I have to manually colour the cells.
>> >
>> > Please advise.
>> >
>> > ile

Thanks Chip. I managed to get the 'colorindex' function to work, but the
'countbycolor' gives an error message. I guess the problem is with the
syntax. I've tried many variations to it, but still can't get it to work.

This means a trip to library and reading VBA basics... :-)

Many thanks for the help.

ile

"Chip Pearson" wrote:

> In the VBA Editor, go to the Insert menu and choose Module. Paste
> the code in that module.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "ile" <ile@discussions.microsoft.com> wrote in message
> news:33DC4F38-9BA1-4F34-879C-8E1EBC8B55ED@microsoft.com...
> > Thanks for the help. Unfortunately I'm not that familiar with
> > VB coding. I
> > copied the code to VB editor, but it didn't work. What am I
> > doing wrong?
> >
> > Any solutions?
> >
> > ile
> >
> > "Gary''s Student" wrote:
> >
> >> See:
> >>
> >> http://www.cpearson.com/excel/colors.htm
> >> --
> >> Gary's Student
> >>
> >>
> >> "ile" wrote:
> >>
> >> > Hi
> >> > How can I count cells which are formatted in colour? I have
> >> > tried the
> >> > countif function, but it does not work. I cannot use the
> >> > conditional
> >> > formatting, because the cell values contain only text, which
> >> > is not
> >> > repeating. So I have to manually colour the cells.
> >> >
> >> > Please advise.
> >> >
> >> > ile
>
>
>