You need to use VBA code. You can't do it with Excel's built in
functions. See http://www.cpearson.com/excel/colors.aspx for details,
examples, and downloadable code.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Fri, 19 Dec 2008 22:40:05 -0800, CraigAllen
wrote:

Hello, I have a work sheet which has a list of things running from A8 down to
A400. They have been manually classified by use of the cell fill colour. Is
there a way that I can show the number of green rows or red row etc?