counting cell that are fomated a particular fill colour
 

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

counting cell that are fomated a particular fill colour
 

"Andrew@rushington" wrote in
message ...
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 he
http://www.cpearson.com/excel/colors.htm

counting cell that are fomated a particular fill colour
 

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" wrote in
message ...
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 he
http://www.cpearson.com/excel/colors.htm

counting cell that are fomated a particular fill colour
 

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

"Andrew@rushington" wrote in
message ...
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" wrote in
message ...
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 he
http://www.cpearson.com/excel/colors.htm

counting cell that are fomated a particular fill colour
 

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" wrote in
message ...
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" wrote in
message ...
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 he
http://www.cpearson.com/excel/colors.htm

counting cell that are fomated a particular fill colour
 

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.

counting cell that are fomated a particular fill colour
 

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
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.

counting cell that are fomated a particular fill colour
 

My Excel 2002 SP3 has this function

counting cell that are fomated a particular fill colour
 

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
wrote:

My Excel 2002 SP3 has this function