counting cell that are fomated a particular fill colour

[Andrew@rushington]

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

 

[Stephen]

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

 

[Andrew@rushington]

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]

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

 

[Andrew@rushington]

yeah i have now, thank for your help.

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

 

[Herbert Seidenberg]

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.

 

[Gord Dibben]

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

 

[Herbert Seidenberg]

My Excel 2002 SP3 has this function

 

[Gord Dibben]

Apologies Herbert

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


Gord