Is there a way a "Novice" could count a range of cells and return how many
are filled with red?

"Andrew@rushington" <(E-Mail Removed)> wrote in
message news:F5AC048B-F921-4133-B0CD-(E-Mail Removed)...
> Is there a way a "Novice" could count a range of cells and return how many
> are filled with red?

This requires a macro. It is well explained here:
http://www.cpearson.com/excel/colors.htm

ok, thay seems to work although i have no experience with VBA i managed it,
but how do i know what colour is what number?
thanks

"Stephen" wrote:

> "Andrew@rushington" <(E-Mail Removed)> wrote in
> message news:F5AC048B-F921-4133-B0CD-(E-Mail Removed)...
> > Is there a way a "Novice" could count a range of cells and return how many
> > are filled with red?
>
> This requires a macro. It is well explained here:
> http://www.cpearson.com/excel/colors.htm
>
>
>

Did you read the section " Returning the ColorIndex of a cell" in the web
page I gave you?

"Andrew@rushington" <(E-Mail Removed)> wrote in
message news:51842321-96A0-448C-9155-(E-Mail Removed)...
> ok, thay seems to work although i have no experience with VBA i managed
> it,
> but how do i know what colour is what number?
> thanks
>
> "Stephen" wrote:
>
>> "Andrew@rushington" <(E-Mail Removed)> wrote in
>> message news:F5AC048B-F921-4133-B0CD-(E-Mail Removed)...
>> > Is there a way a "Novice" could count a range of cells and return how
>> > many
>> > are filled with red?
>>
>> This requires a macro. It is well explained here:
>> http://www.cpearson.com/excel/colors.htm
>>
>>
>>

yeah i have now, thank for your help.



"Stephen" wrote:

> Did you read the section " Returning the ColorIndex of a cell" in the web
> page I gave you?
>
> "Andrew@rushington" <(E-Mail Removed)> wrote in
> message news:51842321-96A0-448C-9155-(E-Mail Removed)...
> > ok, thay seems to work although i have no experience with VBA i managed
> > it,
> > but how do i know what colour is what number?
> > thanks
> >
> > "Stephen" wrote:
> >
> >> "Andrew@rushington" <(E-Mail Removed)> wrote in
> >> message news:F5AC048B-F921-4133-B0CD-(E-Mail Removed)...
> >> > Is there a way a "Novice" could count a range of cells and return how
> >> > many
> >> > are filled with red?
> >>
> >> This requires a macro. It is well explained here:
> >> http://www.cpearson.com/excel/colors.htm
> >>
> >>
> >>
>
>
>

No VBA or color number required:
Edit > Find > Find what: clear it if filled
Options > Format.. > Choose Format from Cell >
Click any red cell > Find All
The number of cells will appear in the lower left
corner of the Find window.

Versions earlier than 2003 do not have this function.

Also, if the cells are colored due to Conditional Formatting it won't work.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 10:48:41 -0800 (PST), Herbert Seidenberg
<herbds7-(E-Mail Removed)> wrote:

>No VBA or color number required:
>Edit > Find > Find what: clear it if filled
>Options > Format.. > Choose Format from Cell >
>Click any red cell > Find All
>The number of cells will appear in the lower left
>corner of the Find window.

My Excel 2002 SP3 has this function

Apologies Herbert

I have not used 2002 for a couple of years so I guess I forgot 2002 had that
function.


Gord

On Fri, 7 Dec 2007 14:14:28 -0800 (PST), Herbert Seidenberg
<herbds7-(E-Mail Removed)> wrote:

>My Excel 2002 SP3 has this function