counting cell that are fomated a particular fill colour

  • Thread starter Andrew@rushington
  • Start date
A

Andrew@rushington

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

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
 
S

Stephen

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

Andrew@rushington

yeah i have now, thank for your help.



Stephen said:
Did you read the section " Returning the ColorIndex of a cell" in the web
page I gave you?
Click to expand...
 
H

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

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
 
G

Gord Dibben

Apologies Herbert

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


Gord
 
Top