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?