Is there an Excel forumla to count different coloured cells?

[Pete_UK]

There isn't a built-in function, but Bob Phillips shows how to do it
with VBA here:

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

Hope this helps.

Pete

 

[JLGWhiz]

Well, formulas at least. VBA is a little different.