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