HOW DO I COUNT CELLS OF A CERTAIN COLOR ONLY?

[Martin C]

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

 

[JE McGimpsey]

See

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

 

[Michael]

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

 

[Gord Dibben]

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