Counting Cells

[LostNFound]

I have cells color coded Red & Green on a spreadsheet. The cells have various
numbers I want to count the green cells is there a formula for this?

[Chip Pearson]

You can't do this with a formula. You need a VBA function. See
www.cpearson.com/excel/colors.htm for details and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"LostNFound" <GottaGo2@Hotmail.com> wrote in message
news:38B5ED0A-A8D7-4290-94BD-0ED2978CFBB0@microsoft.com...
>I have cells color coded Red & Green on a spreadsheet. The cells
>have various
> numbers I want to count the green cells is there a formula for
> this?