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