HOW DO I COUNT CELLS OF A CERTAIN COLOR ONLY?
 

Having trouble counting cells in an excel spreadsheet that have a certain
color only. Can anyone help?

See

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


In article ,
"Martin C" <Martin wrote:

Having trouble counting cells in an excel spreadsheet that have a certain
color only. Can anyone help?

Hi Martin
Basically it can't be done by Excel in its normal configuration.
However, have a look at the site below for adding ColourIndex to Excel,
which will then allow you to count cells and other interesting stuff.

www.xldynamic.com/source/xld.ColourCounter.html

HTH
Michael Mitchelson


"Martin C" wrote:

Having trouble counting cells in an excel spreadsheet that have a certain
color only. Can anyone help?

Martin

How were the cells colored?

If by using Conditional Formatting, count on those conditions.

If manually colored, you will need a User Defined Function.

See Chip Pearson's site for code.

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


Gord Dibben Excel MVP

On Thu, 28 Jul 2005 14:33:03 -0700, "Martin C" <Martin
wrote:

Having trouble counting cells in an excel spreadsheet that have a certain
color only. Can anyone help?