Hi Steven,

See Chip Pearson's page on counting and summing by colour at:

http://www.cpearson.com/excel/colors.htm

See also XlDynamic at:

http://www.xldynamic.com/source/xld.....html#counting


---
Regards,
Norman


"Steven" wrote in message
ups.com...
I need to create a macro does some addition.
For example, I will have some green colored cells in Column A, and I
want C4 displays the total number of green cells in column A.
Thank you for taking your valuable time to read this. Any help would be
appreciated.