count the number of cells that have a particular fill colour?

[Martin Y]

Any idea of how to write a function in excel to count the
number of cells in a range that have a particular fill
colour?

 

[Paul B]

Martin, have a look here http://www.cpearson.com/excel/colors.htm

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Tom Ogilvy]

You would need to use VBA code to write your own function. See Chip
Pearson's site for such a function:

http://www.cpearson.com/excel/colors.htm

 

[Guest]

Thanks works great

-----Original Message-----
Martin, have a look here http://www.cpearson.com/excel/colors.htm

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **



.

 

[Guest]

Thanks works great

-----Original Message-----
You would need to use VBA code to write your own function. See Chip
Pearson's site for such a function:

http://www.cpearson.com/excel/colors.htm

--
Regards,
Tom Ogilvy





.